home *** CD-ROM | disk | FTP | other *** search
| Unknown | 1993-02-01 | 46.5 KB |
open in: 
MacOS 8.1
|
Win98
|
DOS
view JSON data
|
view as text
This file was not able to be converted.
This format is not currently supported by dexvert.
hex view+--------+-------------------------+-------------------------+--------+--------+
|00000000| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000010| 64 03 00 00 00 00 00 00 | 00 00 20 00 c2 05 00 00 |d.......|.. .....|
|00000020| 2b 05 00 fb 03 00 00 00 | 00 00 00 00 00 00 00 00 |+.......|........|
|00000030| 00 00 16 03 00 00 00 00 | 00 00 00 00 00 00 06 01 |........|........|
|00000040| 00 00 00 00 39 01 00 00 | 00 00 00 00 00 1b 04 00 |....9...|........|
|00000050| 00 00 00 00 00 00 00 00 | 00 00 00 00 60 03 00 00 |........|....`...|
|00000060| 00 00 8c 03 24 52 65 67 | 65 6e 65 72 61 74 65 20 |....$Reg|enerate |
|00000070| 69 6e 64 65 78 65 73 20 | 28 53 68 69 66 74 2d 46 |indexes |(Shift-F|
|00000080| 39 2c 20 31 2c 20 32 29 | 2e ff ff fd 45 72 72 6f |9, 1, 2)|....Erro|
|00000090| 72 20 31 30 32 20 63 61 | 6e 20 62 65 20 63 61 75 |r 102 ca|n be cau|
|000000a0| 73 65 64 20 62 79 20 63 | 72 65 61 74 69 6e 67 20 |sed by c|reating |
|000000b0| 61 20 70 72 6f 6d 70 74 | 20 66 6f 72 20 61 20 72 |a prompt| for a r|
|000000c0| 65 70 6f 72 74 20 76 61 | 72 69 61 62 6c 65 20 61 |eport va|riable a|
|000000d0| 6e 64 20 74 65 6c 6c 69 | 6e 67 20 44 61 74 61 50 |nd telli|ng DataP|
|000000e0| 65 72 66 65 63 74 20 74 | 68 65 20 66 69 65 6c 64 |erfect t|he field|
|000000f0| 20 66 6f 72 6d 61 74 20 | 69 73 20 61 20 6d 75 6c | format |is a mul|
|00000100| 74 69 2d 6c 69 6e 65 64 | 20 74 65 78 74 20 66 69 |ti-lined| text fi|
|00000110| 65 6c 64 20 28 69 2e 65 | 2e 20 41 31 30 41 32 29 |eld (i.e|. A10A2)|
|00000120| 2e 20 20 45 72 72 6f 72 | 20 31 39 37 2c 20 61 6e |. Error| 197, an|
|00000130| 64 20 74 68 65 6e 20 31 | 30 32 20 77 69 6c 6c 20 |d then 1|02 will |
|00000140| 61 70 70 65 61 72 20 77 | 68 65 6e 20 74 68 65 20 |appear w|hen the |
|00000150| 72 65 70 6f 72 74 20 69 | 73 20 72 75 6e 20 66 6f |report i|s run fo|
|00000160| 72 20 74 68 65 20 66 69 | 72 73 74 20 74 69 6d 65 |r the fi|rst time|
|00000170| 2e 20 20 54 68 65 20 75 | 73 65 72 20 77 69 6c 6c |. The u|ser will|
|00000180| 20 62 65 20 75 6e 61 62 | 6c fd 65 20 74 6f 20 72 | be unab|l.e to r|
|00000190| 65 2d 65 6e 74 65 72 20 | 74 68 65 20 64 61 74 61 |e-enter |the data|
|000001a0| 62 61 73 65 20 61 6e 64 | 20 77 69 6c 6c 20 72 65 |base and| will re|
|000001b0| 63 65 69 76 65 20 74 68 | 65 20 65 72 72 6f 72 20 |ceive th|e error |
|000001c0| 31 30 32 2e 20 20 54 68 | 69 73 20 70 72 6f 62 6c |102. Th|is probl|
|000001d0| 65 6d 20 63 61 6e 20 62 | 65 20 63 6f 72 72 65 63 |em can b|e correc|
|000001e0| 74 65 64 20 62 79 20 64 | 65 6c 65 74 69 6e 67 20 |ted by d|eleting |
|000001f0| 74 68 65 20 2e 49 4e 44 | 20 66 69 6c 65 2c 20 72 |the .IND| file, r|
|00000200| 65 69 6e 64 65 78 69 6e | 67 20 74 68 65 20 64 61 |eindexin|g the da|
|00000210| 74 61 62 61 73 65 2c 20 | 61 6e 64 20 52 45 4d 4f |tabase, |and REMO|
|00000220| 56 49 4e 47 20 54 48 45 | 20 50 52 4f 4d 50 54 2e |VING THE| PROMPT.|
|00000230| 20 20 49 66 20 79 6f 75 | 20 64 6f 20 6e 6f 74 20 | If you| do not |
|00000240| 72 65 6d 6f 76 65 20 74 | 68 65 20 70 72 6f 6d 70 |remove t|he promp|
|00000250| 74 2c 20 74 68 69 73 20 | 70 72 6f 62 6c 65 6d 20 |t, this |problem |
|00000260| 77 69 6c 6c 20 72 65 61 | 70 70 65 61 72 20 77 68 |will rea|ppear wh|
|00000270| 65 6e 20 74 68 65 20 72 | 65 70 6f 72 74 20 69 73 |en the r|eport is|
|00000280| 20 72 75 6e 20 61 67 04 | 61 69 6e 2e ff ff aa 49 | run ag.|ain....I|
|00000290| 66 20 79 6f 75 20 67 65 | 74 20 45 72 72 6f 72 20 |f you ge|t Error |
|000002a0| 31 30 32 20 77 68 65 6e | 20 74 72 79 69 6e 67 20 |102 when| trying |
|000002b0| 74 6f 20 65 6e 74 65 72 | 20 61 20 6c 69 73 74 20 |to enter| a list |
|000002c0| 6f 66 20 70 61 6e 65 6c | 73 2c 20 74 68 65 6e 20 |of panel|s, then |
|000002d0| 45 72 72 6f 72 20 31 32 | 31 20 77 68 65 6e 20 74 |Error 12|1 when t|
|000002e0| 72 79 69 6e 67 20 74 6f | 20 72 75 6e 20 44 50 45 |rying to| run DPE|
|000002f0| 58 50 20 6f 6e 20 74 68 | 65 20 73 74 72 75 63 74 |XP on th|e struct|
|00000300| 75 72 65 2c 20 73 74 6f | 70 70 69 6e 67 20 6f 6e |ure, sto|pping on|
|00000310| 20 6f 6e 65 20 6f 66 20 | 74 68 65 20 72 65 70 6f | one of |the repo|
|00000320| 72 74 73 20 61 6e 64 20 | 74 68 65 6e 20 74 65 72 |rts and |then ter|
|00000330| 6d 69 6e 61 74 69 6e 67 | 3a ff b4 52 75 6e 20 44 |minating|:..Run D|
|00000340| 50 4f 52 44 45 52 20 61 | 6e 64 20 64 65 6c 65 74 |PORDER a|nd delet|
|00000350| 65 20 74 68 65 20 72 65 | 70 6f 72 74 2e 20 20 54 |e the re|port. T|
|00000360| 6f 20 64 6f 20 74 68 69 | 73 2c 20 68 69 67 68 6c |o do thi|s, highl|
|00000370| 69 67 68 74 20 74 68 65 | 20 72 65 70 6f 72 74 20 |ight the| report |
|00000380| 6e 61 6d 65 20 61 6e 64 | 20 70 72 65 73 73 20 44 |name and| press D|
|00000390| 65 6c 65 74 65 2e 20 20 | 41 66 74 65 72 20 65 78 |elete. |After ex|
|000003a0| 69 74 69 6e 67 20 61 6e | 64 20 73 61 76 69 6e 67 |iting an|d saving|
|000003b0| 20 61 6e 64 20 74 68 65 | 6e 20 72 75 6e 6e 69 6e | and the|n runnin|
|000003c0| 67 20 44 50 45 58 50 2f | 44 50 49 4d 50 2c 20 74 |g DPEXP/|DPIMP, t|
|000003d0| 68 65 20 70 72 6f 62 6c | 65 6d 20 73 68 6f 75 6c |he probl|em shoul|
|000003e0| 64 20 62 65 20 63 6f 72 | 72 65 63 74 65 64 2e 00 |d be cor|rected..|
|000003f0| 64 61 79 5b 74 6f 64 61 | 79 5d 3b 28 6d 6f 6e 74 |day[toda|y];(mont|
|00000400| 1d 00 72 01 97 45 78 69 | 74 20 66 72 6f 6d 20 44 |..r..Exi|t from D|
|00000410| 61 74 61 50 65 72 66 65 | 63 74 20 61 6e 64 20 72 |ataPerfe|ct and r|
|00000420| 65 73 74 61 72 74 20 77 | 69 74 68 20 74 68 65 20 |estart w|ith the |
|00000430| 2f 4c 20 6f 70 74 69 6f | 6e 20 28 69 2e 65 2e 20 |/L optio|n (i.e. |
|00000440| 64 70 20 2f 4c 29 2e 20 | 20 52 65 6d 6f 76 69 6e |dp /L). | Removin|
|00000450| 67 20 54 53 52 73 20 6f | 72 20 6f 74 68 65 72 20 |g TSRs o|r other |
|00000460| 70 72 6f 67 72 61 6d 73 | 20 74 61 6b 69 6e 67 20 |programs| taking |
|00000470| 6d 65 6d 6f 72 79 20 61 | 6c 73 6f 20 63 61 6e 20 |memory a|lso can |
|00000480| 68 65 6c 70 20 74 6f 20 | 65 6c 69 6d 69 6e 61 74 |help to |eliminat|
|00000490| 65 20 74 68 65 20 65 72 | 72 6f 72 2e ff a7 28 4e |e the er|ror...(N|
|000004a0| 65 74 77 6f 72 6b 29 20 | 41 6e 6f 74 68 65 72 20 |etwork) |Another |
|000004b0| 70 6f 73 73 69 62 6c 65 | 20 73 6f 6c 75 74 69 6f |possible| solutio|
|000004c0| 6e 20 69 73 20 74 6f 20 | 63 68 65 63 6b 20 74 6f |n is to |check to|
|000004d0| 20 73 65 65 20 68 6f 77 | 20 74 68 65 20 64 61 74 | see how| the dat|
|000004e0| 61 62 61 73 65 20 66 69 | 6c 65 73 20 61 72 65 20 |abase fi|les are |
|000004f0| 66 6c 61 67 67 65 64 2e | 20 20 49 66 20 74 68 65 |flagged.| If the|
|00000500| 79 20 61 72 65 20 66 6c | 61 67 67 65 64 20 4e 6f |y are fl|agged No|
|00000510| 6e 2d 53 68 61 72 61 62 | 6c 65 20 52 65 61 64 2f |n-Sharab|le Read/|
|00000520| 57 72 69 74 65 2c 20 74 | 68 61 74 20 63 61 6e 20 |Write, t|hat can |
|00000530| 61 6c 73 6f 20 63 61 75 | 73 65 20 74 68 65 20 65 |also cau|se the e|
|00000540| 72 72 6f 72 2e ff 2e 49 | 66 20 70 72 6f 62 6c 65 |rror...I|f proble|
|00000550| 6d 73 20 70 65 72 73 69 | 73 74 2c 20 73 69 6d 70 |ms persi|st, simp|
|00000560| 6c 69 66 79 20 70 61 6e | 65 6c 73 2f 66 6f 72 6d |lify pan|els/form|
|00000570| 75 6c 61 73 2e 00 20 74 | 6f 20 32 2f 32 2f 39 31 |ulas.. t|o 2/2/91|
|00000580| 0c 00 61 00 5f 54 72 79 | 20 75 73 69 6e 67 20 61 |..a._Try| using a|
|00000590| 20 64 69 66 66 65 72 65 | 6e 74 20 64 69 73 6b 2e | differe|nt disk.|
|000005a0| 20 20 43 61 6e 20 62 65 | 20 63 61 75 73 65 64 20 | Can be| caused |
|000005b0| 62 79 20 73 65 74 74 69 | 6e 67 20 74 68 65 20 52 |by setti|ng the R|
|000005c0| 45 41 44 2d 4f 4e 4c 59 | 20 61 74 74 72 69 62 75 |EAD-ONLY| attribu|
|000005d0| 74 65 20 6f 6e 20 74 68 | 65 20 2e 53 54 52 20 66 |te on th|e .STR f|
|000005e0| 69 6c 65 2e 00 3b 34 5d | 5d 5d 00 20 50 31 46 32 |ile..;4]|]]. P1F2|
|000005f0| ff 13 65 6c 73 65 20 22 | 22 20 65 6e 64 69 66 20 |..else "|" endif |
|00000600| 04 00 1d 00 1b 45 72 72 | 6f 72 20 77 68 69 6c 65 |.....Err|or while|
|00000610| 20 72 65 61 64 69 6e 67 | 20 61 20 66 69 6c 65 2e | reading| a file.|
|00000620| 00 00 00 00 01 00 3b 00 | 00 00 00 00 20 31 29 ff |......;.|.... 1).|
|00000630| 05 65 6e 64 69 66 00 69 | 73 70 6c 61 79 20 74 68 |.endif.i|splay th|
|00000640| 02 00 5c 02 fd 49 66 20 | 74 68 69 73 20 6f 63 63 |..\..If |this occ|
|00000650| 75 72 73 20 66 6f 72 20 | 74 68 65 20 2e 54 58 58 |urs for |the .TXX|
|00000660| 20 66 69 6c 65 2c 20 74 | 68 65 20 6d 6f 73 74 20 | file, t|he most |
|00000670| 6c 69 6b 65 6c 79 20 70 | 72 6f 62 6c 65 6d 20 69 |likely p|roblem i|
|00000680| 73 20 74 68 61 74 20 74 | 68 65 20 2e 54 58 58 20 |s that t|he .TXX |
|00000690| 66 69 6c 65 20 68 61 73 | 20 67 6f 74 74 65 6e 20 |file has| gotten |
|000006a0| 6f 75 74 20 6f 66 20 73 | 65 71 75 65 6e 63 65 2e |out of s|equence.|
|000006b0| 20 20 59 6f 75 20 73 68 | 6f 75 6c 64 20 65 78 70 | You sh|ould exp|
|000006c0| 6f 72 74 20 61 6c 6c 20 | 64 61 74 61 20 66 6f 72 |ort all |data for|
|000006d0| 6d 20 74 68 65 20 64 61 | 74 61 62 61 73 65 2c 20 |m the da|tabase, |
|000006e0| 65 72 61 73 65 20 74 68 | 65 20 2e 54 58 58 20 2e |erase th|e .TXX .|
|000006f0| 49 4e 44 20 61 6e 64 20 | 61 6c 6c 20 64 61 74 61 |IND and |all data|
|00000700| 20 66 69 6c 65 73 2c 20 | 61 6e 64 20 69 6d 70 6f | files, |and impo|
|00000710| 72 74 20 74 68 65 20 64 | 61 74 61 2e 20 20 54 68 |rt the d|ata. Th|
|00000720| 65 20 65 72 72 6f 72 20 | 6d 65 73 73 61 67 65 73 |e error |messages|
|00000730| 20 65 6e 63 6f 75 6e 74 | 65 72 65 64 20 64 75 72 | encount|ered dur|
|00000740| 69 6e 49 67 20 65 78 70 | 6f 72 74 20 63 61 6e 20 |inIg exp|ort can |
|00000750| 62 65 20 69 67 6e 6f 72 | 65 64 20 65 78 63 65 70 |be ignor|ed excep|
|00000760| 74 20 74 6f 20 6e 6f 74 | 65 20 77 68 65 72 65 20 |t to not|e where |
|00000770| 74 68 65 20 62 61 64 20 | 74 65 78 74 20 69 73 20 |the bad |text is |
|00000780| 69 6e 20 74 68 65 20 64 | 61 74 61 2e ff ff 4d 49 |in the d|ata...MI|
|00000790| 66 20 61 20 72 65 61 64 | 20 65 72 72 6f 72 20 6f |f a read| error o|
|000007a0| 63 63 75 72 73 20 69 6e | 20 74 68 65 20 2e 49 4e |ccurs in| the .IN|
|000007b0| 44 20 66 69 6c 65 2c 20 | 65 72 61 73 65 20 69 74 |D file, |erase it|
|000007c0| 20 61 6e 64 20 72 65 67 | 65 6e 65 72 61 74 65 20 | and reg|enerate |
|000007d0| 74 68 65 20 69 6e 64 65 | 78 65 73 2e ff ff c0 49 |the inde|xes....I|
|000007e0| 66 20 61 20 72 65 61 64 | 20 65 72 72 6f 72 20 6f |f a read| error o|
|000007f0| 63 63 75 72 73 20 69 6e | 20 61 20 70 61 6e 65 6c |ccurs in| a panel|
|00000800| 20 66 69 6c 65 2c 20 79 | 6f 75 20 77 69 6c 6c 20 | file, y|ou will |
|00000810| 70 72 6f 62 61 62 6c 79 | 20 68 61 76 65 20 74 6f |probably| have to|
|00000820| 20 75 73 65 20 61 20 62 | 61 63 6b 75 70 20 63 6f | use a b|ackup co|
|00000830| 70 79 20 6f 66 20 74 68 | 65 20 64 61 74 61 20 28 |py of th|e data (|
|00000840| 70 72 65 66 65 72 61 62 | 6c 79 20 69 6e 20 65 78 |preferab|ly in ex|
|00000850| 70 6f 72 74 65 64 20 66 | 6f 72 6d 29 2e 20 20 59 |ported f|orm). Y|
|00000860| 6f 75 20 6d 61 79 20 62 | 65 20 61 62 6c 65 20 74 |ou may b|e able t|
|00000870| 6f 20 65 78 70 6f 72 74 | 20 74 68 65 20 64 61 74 |o export| the dat|
|00000880| 61 20 61 6e 64 20 72 65 | 2d 65 6e 74 65 72 20 6d |a and re|-enter m|
|00000890| 69 73 73 69 6e 67 20 72 | 65 63 6f 72 64 73 2e 00 |issing r|ecords..|
|000008a0| 13 00 4c 00 4a 45 72 72 | 6f 72 20 69 6e 20 65 78 |..L.JErr|or in ex|
|000008b0| 74 65 6e 64 69 6e 67 20 | 61 20 66 69 6c 65 20 28 |tending |a file (|
|000008c0| 6e 6f 74 20 65 6e 6f 75 | 67 68 20 64 69 73 6b 20 |not enou|gh disk |
|000008d0| 73 70 61 63 65 29 2e 20 | 20 4e 65 74 77 6f 72 6b |space). | Network|
|000008e0| 20 6f 72 20 64 69 73 6b | 20 65 72 72 6f 72 2e 00 | or disk| error..|
|000008f0| 20 61 67 65 20 74 6f 20 | 74 68 65 20 65 78 61 63 | age to |the exac|
|00000900| 03 00 7c 00 7a 55 73 65 | 20 61 20 64 69 73 6b 20 |..|.zUse| a disk |
|00000910| 74 68 61 74 20 68 61 73 | 20 6d 6f 72 65 20 73 70 |that has| more sp|
|00000920| 61 63 65 20 61 76 61 69 | 6c 61 62 6c 65 2e 20 20 |ace avai|lable. |
|00000930| 43 61 6e 20 62 65 20 63 | 61 75 73 65 64 20 62 79 |Can be c|aused by|
|00000940| 20 68 61 76 69 6e 67 20 | 74 6f 6f 20 6d 61 6e 79 | having |too many|
|00000950| 20 66 69 6c 65 73 20 61 | 6c 72 65 61 64 79 20 73 | files a|lready s|
|00000960| 61 76 65 64 20 69 6e 20 | 74 68 69 73 20 64 69 73 |aved in |this dis|
|00000970| 6b 20 6f 72 20 64 69 72 | 65 63 74 6f 72 79 2e 00 |k or dir|ectory..|
|00000980| 04 00 86 00 84 4e 6f 74 | 20 65 6e 6f 75 67 68 20 |.....Not| enough |
|00000990| 64 69 72 65 63 74 6f 72 | 79 20 62 6c 6f 63 6b 73 |director|y blocks|
|000009a0| 20 6f 6e 20 74 68 65 20 | 64 69 73 6b 20 74 6f 20 | on the |disk to |
|000009b0| 61 6c 6c 6f 63 61 74 65 | 20 61 6e 6f 74 68 65 72 |allocate| another|
|000009c0| 20 66 69 6c 65 2e 20 20 | 54 68 65 72 65 20 61 72 | file. |There ar|
|000009d0| 65 20 61 6c 72 65 61 64 | 79 20 74 6f 6f 20 6d 61 |e alread|y too ma|
|000009e0| 6e 79 20 66 69 6c 65 73 | 20 73 61 76 65 64 20 69 |ny files| saved i|
|000009f0| 6e 20 74 68 69 73 20 64 | 69 72 65 63 74 6f 72 79 |n this d|irectory|
|00000a00| 20 6f 72 20 64 69 73 6b | 2e 00 72 6e 20 61 6c 6c | or disk|..rn all|
|00000a10| 20 6d 61 74 63 68 69 6e | 67 20 72 65 63 6f 72 64 | matchin|g record|
|00000a20| 05 00 84 00 82 42 61 63 | 6b 20 75 70 20 74 68 65 |.....Bac|k up the|
|00000a30| 20 64 61 74 61 20 61 6e | 64 20 72 65 66 6f 72 6d | data an|d reform|
|00000a40| 61 74 20 74 68 65 20 64 | 69 73 6b 20 77 69 74 68 |at the d|isk with|
|00000a50| 20 6d 6f 72 65 20 64 69 | 72 65 63 74 6f 72 79 20 | more di|rectory |
|00000a60| 62 6c 6f 63 6b 73 2c 20 | 6f 72 20 70 6c 61 63 65 |blocks, |or place|
|00000a70| 20 74 68 65 20 66 69 6c | 65 20 6f 6e 20 61 6e 6f | the fil|e on ano|
|00000a80| 74 68 65 72 20 64 69 73 | 6b 2e 20 20 54 72 79 20 |ther dis|k. Try |
|00000a90| 75 73 69 6e 67 20 61 20 | 64 69 66 66 65 72 65 6e |using a |differen|
|00000aa0| 74 20 64 69 73 6b 2e 00 | 6e 63 74 69 6f 6e 20 61 |t disk..|nction a|
|00000ab0| 73 20 ba 44 61 74 61 50 | 65 72 66 65 63 74 20 77 |s .DataP|erfect w|
|00000ac0| 05 00 24 00 22 41 74 74 | 65 6d 70 74 20 74 6f 20 |..$."Att|empt to |
|00000ad0| 6f 70 65 6e 20 62 61 64 | 20 63 6f 6e 74 72 6f 6c |open bad| control|
|00000ae0| 20 62 6c 6f 63 6b 2e 00 | 6c 64 20 63 6f 6e 74 65 | block..|ld conte|
|00000af0| 6e 74 73 2e 20 20 55 73 | 69 6e 67 20 74 68 65 20 |nts. Us|ing the |
|00000b00| 02 00 91 00 8f 4d 6f 64 | 69 66 79 69 6e 67 20 74 |.....Mod|ifying t|
|00000b10| 68 65 20 2e 53 54 52 20 | 66 69 6c 65 20 69 6e 20 |he .STR |file in |
|00000b20| 61 6e 20 41 53 43 49 49 | 20 54 65 78 74 20 45 64 |an ASCII| Text Ed|
|00000b30| 69 74 6f 72 20 28 50 2d | 45 64 69 74 29 20 63 61 |itor (P-|Edit) ca|
|00000b40| 6e 20 6c 65 61 64 20 74 | 6f 20 74 68 69 73 20 65 |n lead t|o this e|
|00000b50| 72 72 6f 72 2e 20 20 59 | 6f 75 20 77 69 6c 6c 20 |rror. Y|ou will |
|00000b60| 6e 65 65 64 20 74 6f 20 | 75 73 65 20 61 20 62 61 |need to |use a ba|
|00000b70| 63 6b 75 70 20 6f 66 20 | 74 68 65 20 64 61 74 61 |ckup of |the data|
|00000b80| 62 61 73 65 20 6f 72 20 | 72 65 64 65 66 69 6e 65 |base or |redefine|
|00000b90| 20 69 74 2e 00 62 65 72 | 20 46 69 65 6c 64 2e ff | it..ber| Field..|
|00000ba0| 05 00 3b 00 39 41 63 63 | 65 73 73 20 64 65 6e 69 |..;.9Acc|ess deni|
|00000bb0| 65 64 20 69 6e 20 6e 65 | 74 77 6f 72 6b 2e 20 20 |ed in ne|twork. |
|00000bc0| 46 69 6c 65 20 69 73 20 | 66 6c 61 67 67 65 64 20 |File is |flagged |
|00000bd0| 6e 6f 6e 2d 73 68 61 72 | 65 61 62 6c 65 2e 00 6d |non-shar|eable..m|
|00000be0| 02 00 71 00 6f 54 68 65 | 20 2e 49 4e 44 2c 20 2e |..q.oThe| .IND, .|
|00000bf0| 54 58 58 2c 20 6f 72 20 | 6f 6e 65 20 6f 66 20 74 |TXX, or |one of t|
|00000c00| 68 65 20 64 61 74 61 20 | 66 69 6c 65 73 20 69 73 |he data |files is|
|00000c10| 20 66 6c 61 67 67 65 64 | 20 6e 6f 6e 2d 73 68 61 | flagged| non-sha|
|00000c20| 72 65 61 62 6c 65 20 61 | 6e 64 20 6e 65 65 64 73 |reable a|nd needs|
|00000c30| 20 74 6f 20 62 65 20 66 | 6c 61 67 67 65 64 20 73 | to be f|lagged s|
|00000c40| 68 61 72 65 61 62 6c 65 | 20 72 65 61 64 2d 77 72 |hareable| read-wr|
|00000c50| 69 74 65 2e 00 64 65 20 | 66 69 65 6c 64 2e ff d3 |ite..de |field...|
|00000c60| 04 00 53 00 51 4d 75 6c | 74 69 70 6c 65 20 63 61 |..S.QMul|tiple ca|
|00000c70| 75 73 65 73 2e 20 20 55 | 73 75 61 6c 6c 79 20 70 |uses. U|sually p|
|00000c80| 72 65 63 65 64 65 64 20 | 62 79 20 61 6e 20 61 64 |receded |by an ad|
|00000c90| 64 69 74 69 6f 6e 61 6c | 2c 20 6d 6f 72 65 20 73 |ditional|, more s|
|00000ca0| 70 65 63 69 66 69 63 20 | 65 72 72 6f 72 20 6d 65 |pecific |error me|
|00000cb0| 73 73 61 67 65 2e 00 20 | 63 6f 6e 66 69 72 6d 73 |ssage.. |confirms|
|00000cc0| 03 00 ab 01 fd 53 6f 6d | 65 20 65 72 72 6f 72 73 |.....Som|e errors|
|00000cd0| 20 63 61 6e 20 62 65 20 | 66 69 78 65 64 20 77 69 | can be |fixed wi|
|00000ce0| 74 68 20 44 50 49 4e 46 | 4f 2e 20 20 49 66 20 44 |th DPINF|O. If D|
|00000cf0| 50 49 4e 46 4f 20 64 65 | 74 65 63 74 73 20 61 20 |PINFO de|tects a |
|00000d00| 70 72 6f 62 6c 65 6d 20 | 69 74 20 63 61 6e 20 63 |problem |it can c|
|00000d10| 6f 72 72 65 63 74 2c 20 | 69 74 20 77 69 6c 6c 20 |orrect, |it will |
|00000d20| 66 6c 61 67 20 74 68 65 | 20 70 61 6e 65 6c 20 77 |flag the| panel w|
|00000d30| 69 74 68 20 61 6e 20 61 | 73 74 65 72 69 73 6b 20 |ith an a|sterisk |
|00000d40| 2a 2e 20 20 49 66 20 79 | 6f 75 20 73 65 65 20 61 |*. If y|ou see a|
|00000d50| 6e 20 61 73 74 65 72 69 | 73 6b 20 62 79 20 61 20 |n asteri|sk by a |
|00000d60| 70 61 6e 65 6c 2c 20 79 | 6f 75 20 6d 61 79 20 74 |panel, y|ou may t|
|00000d70| 68 65 6e 20 72 65 73 74 | 61 72 74 20 77 69 74 68 |hen rest|art with|
|00000d80| 20 74 68 65 20 2f 66 20 | 66 69 78 20 6f 70 74 69 | the /f |fix opti|
|00000d90| 6f 6e 2e 20 28 41 74 20 | 74 68 65 20 44 4f 53 20 |on. (At |the DOS |
|00000da0| 70 72 6f 6d 70 74 2c 20 | 65 6e 74 65 72 20 64 70 |prompt, |enter dp|
|00000db0| 69 6e 66 6f 20 66 6f 6c | 6c 6f 77 65 64 20 62 79 |info fol|lowed by|
|00000dc0| 20 74 73 68 65 20 64 61 | 74 61 62 61 73 65 20 6e | tshe da|tabase n|
|00000dd0| 61 6d 65 20 61 6e 64 20 | 74 68 65 6e 20 2f 66 2e |ame and |then /f.|
|00000de0| 29 20 20 41 66 74 65 72 | 20 44 50 49 4e 46 4f 20 |) After| DPINFO |
|00000df0| 68 61 73 20 66 69 78 65 | 64 20 74 68 65 20 70 61 |has fixe|d the pa|
|00000e00| 6e 65 6c 2c 20 74 68 65 | 20 6c 65 74 74 65 72 20 |nel, the| letter |
|00000e10| 46 20 77 69 6c 6c 20 62 | 65 20 64 69 73 70 6c 61 |F will b|e displa|
|00000e20| 79 65 64 20 6e 65 78 74 | 20 74 6f 20 74 68 65 20 |yed next| to the |
|00000e30| 70 61 6e 65 6c 2e ff ff | 35 59 6f 75 20 6d 61 79 |panel...|5You may|
|00000e40| 20 61 6c 73 6f 20 77 61 | 6e 74 20 74 6f 20 72 75 | also wa|nt to ru|
|00000e50| 6e 20 44 50 45 58 50 2f | 44 50 49 4d 50 20 6f 6e |n DPEXP/|DPIMP on|
|00000e60| 20 74 68 65 20 64 61 74 | 65 62 61 73 65 2e 00 74 | the dat|ebase..t|
|00000e70| 72 69 6e 67 20 69 6e 20 | 50 23 46 23 20 77 69 74 |ring in |P#F# wit|
|00000e80| 0e 00 54 00 52 49 6c 6c | 65 67 61 6c 20 70 69 63 |..T.RIll|egal pic|
|00000e90| 74 75 72 65 20 65 6e 63 | 6f 75 6e 74 65 72 65 64 |ture enc|ountered|
|00000ea0| 2e 20 20 41 20 72 65 70 | 6f 72 74 20 68 61 73 20 |. A rep|ort has |
|00000eb0| 62 65 65 6e 20 6d 6f 64 | 69 66 69 65 64 20 74 6f |been mod|ified to|
|00000ec0| 20 6e 6f 20 6c 6f 6e 67 | 65 72 20 62 65 20 61 63 | no long|er be ac|
|00000ed0| 63 75 72 61 74 65 2e 00 | 65 20 77 69 6c 6c 20 62 |curate..|e will b|
|00000ee0| 03 00 d1 00 cf 43 61 6e | 20 62 65 20 63 61 75 73 |.....Can| be caus|
|00000ef0| 65 64 20 62 79 20 61 20 | 72 65 70 6f 72 74 20 74 |ed by a |report t|
|00000f00| 68 61 74 20 72 65 66 65 | 72 65 6e 63 65 73 20 66 |hat refe|rences f|
|00000f10| 69 65 6c 64 73 2f 69 6e | 64 65 78 65 73 2f 52 56 |ields/in|dexes/RV|
|00000f20| 73 20 28 66 6f 72 6d 75 | 6c 61 73 20 69 6e 20 52 |s (formu|las in R|
|00000f30| 56 73 29 20 74 68 61 74 | 20 68 61 76 65 20 73 69 |Vs) that| have si|
|00000f40| 6e 63 65 20 62 65 65 6e | 20 64 65 6c 65 74 65 64 |nce been| deleted|
|00000f50| 2e 20 20 45 69 74 68 65 | 72 20 72 65 64 65 66 69 |. Eithe|r redefi|
|00000f60| 6e 65 20 74 68 65 20 72 | 65 70 6f 72 74 20 6f 72 |ne the r|eport or|
|00000f70| 20 64 65 6c 65 74 65 20 | 74 68 65 20 72 65 66 65 | delete |the refe|
|00000f80| 72 65 6e 63 65 73 20 74 | 6f 20 69 6e 66 6f 72 6d |rences t|o inform|
|00000f90| 61 74 69 6f 6e 20 74 68 | 61 74 20 68 61 73 20 61 |ation th|at has a|
|00000fa0| 6c 72 65 61 64 79 20 62 | 65 65 6e 20 64 65 6c 65 |lready b|een dele|
|00000fb0| 74 65 64 2e 00 3b 31 30 | 3b 31 39 38 39 5d 20 61 |ted..;10|;1989] a|
|00000fc0| 07 00 83 00 81 52 65 66 | 65 72 65 6e 63 65 20 74 |.....Ref|erence t|
|00000fd0| 6f 20 6e 6f 6e 65 78 69 | 73 74 65 6e 74 20 69 6e |o nonexi|stent in|
|00000fe0| 64 65 78 20 72 6f 6f 74 | 2e 20 20 41 6e 20 69 6e |dex root|. An in|
|00000ff0| 64 65 78 20 74 68 61 74 | 20 77 61 73 20 75 73 65 |dex that| was use|
|00001000| 64 20 69 6e 20 61 20 6c | 69 6e 6b 2c 20 72 65 70 |d in a l|ink, rep|
|00001010| 6f 72 74 2c 20 6f 72 20 | 6c 6f 6f 6b 75 70 20 68 |ort, or |lookup h|
|00001020| 61 73 20 62 65 65 6e 20 | 64 65 6c 65 74 65 64 20 |as been |deleted |
|00001030| 6f 72 20 68 61 73 20 62 | 65 65 6e 20 63 6f 72 72 |or has b|een corr|
|00001040| 75 70 74 65 64 2e 00 39 | 30 30 30 30 30 00 47 39 |upted..9|00000.G9|
|00001050| 39 39 39 22 3b 73 75 62 | 66 69 65 6c 64 5b 50 31 |999";sub|field[P1|
|00001060| 05 00 93 00 91 49 66 20 | 74 68 65 20 69 6e 64 65 |.....If |the inde|
|00001070| 78 20 68 61 73 20 62 65 | 65 6e 20 64 65 6c 65 74 |x has be|en delet|
|00001080| 65 64 2c 20 72 65 64 65 | 66 69 6e 65 20 74 68 65 |ed, rede|fine the|
|00001090| 20 6c 69 6e 6b 2c 20 72 | 65 70 6f 72 74 2c 20 6f | link, r|eport, o|
|000010a0| 72 20 6c 6f 6f 6b 75 70 | 2e 20 20 49 66 20 74 68 |r lookup|. If th|
|000010b0| 65 20 69 6e 64 65 78 65 | 73 20 61 72 65 20 63 6f |e indexe|s are co|
|000010c0| 72 72 75 70 74 2c 20 72 | 65 67 65 6e 65 72 61 74 |rrupt, r|egenerat|
|000010d0| 65 2e 20 20 59 6f 75 20 | 6d 61 79 20 77 61 6e 74 |e. You |may want|
|000010e0| 20 74 6f 20 72 65 67 65 | 6e 65 72 61 74 65 20 61 | to rege|nerate a|
|000010f0| 6e 79 77 61 79 2e 00 1a | 73 75 62 66 69 65 6c 64 |nyway...|subfield|
|00001100| 05 00 54 00 52 42 61 64 | 20 70 61 6e 65 6c 20 73 |..T.RBad| panel s|
|00001110| 74 72 75 63 74 75 72 65 | 20 28 74 61 72 67 65 74 |tructure| (target|
|00001120| 20 70 61 74 68 29 2e 20 | 20 41 20 72 65 66 65 72 | path). | A refer|
|00001130| 65 6e 63 65 20 74 6f 20 | 61 20 64 65 6c 65 74 65 |ence to |a delete|
|00001140| 64 20 70 61 6e 65 6c 20 | 68 61 73 20 62 65 65 6e |d panel |has been|
|00001150| 20 66 6f 75 6e 64 2e 00 | 63 61 73 65 20 63 76 20 | found..|case cv |
|00001160| 03 00 54 00 52 54 68 69 | 73 20 63 6f 75 6c 64 20 |..T.RThi|s could |
|00001170| 68 61 70 70 65 6e 20 69 | 6e 20 61 20 73 75 62 72 |happen i|n a subr|
|00001180| 65 70 6f 72 74 2c 20 72 | 65 70 6f 72 74 2c 20 66 |eport, r|eport, f|
|00001190| 6f 72 6d 75 6c 61 2c 20 | 6f 72 20 6c 69 6e 6b 2e |ormula, |or link.|
|000011a0| 20 20 52 65 6d 6f 76 65 | 20 74 68 65 20 72 65 66 | Remove| the ref|
|000011b0| 65 72 65 6e 63 65 2e 00 | 6e 64 6f 66 ff 20 63 61 |erence..|ndof. ca|
|000011c0| 03 00 35 00 33 55 6e 64 | 65 66 69 6e 65 64 20 73 |..5.3Und|efined s|
|000011d0| 65 61 72 63 68 20 74 79 | 70 65 2e 20 20 54 68 65 |earch ty|pe. The|
|000011e0| 20 2e 53 54 52 20 66 69 | 6c 65 20 69 73 20 63 6f | .STR fi|le is co|
|000011f0| 72 72 75 70 74 65 64 2e | 00 37 20 65 6e 64 6f 66 |rrupted.|.7 endof|
|00001200| 02 00 b6 00 b4 43 6f 75 | 6c 64 20 62 65 20 63 61 |.....Cou|ld be ca|
|00001210| 75 73 65 64 20 62 79 20 | 63 72 65 61 74 69 6e 67 |used by |creating|
|00001220| 20 73 65 61 72 63 68 20 | 63 6f 6e 64 69 74 69 6f | search |conditio|
|00001230| 6e 73 20 69 6e 20 61 20 | 72 65 70 6f 72 74 20 74 |ns in a |report t|
|00001240| 68 65 6e 20 64 65 6c 65 | 74 69 6e 67 20 74 68 65 |hen dele|ting the|
|00001250| 20 66 69 65 6c 64 73 20 | 75 73 65 20 69 6e 20 74 | fields |use in t|
|00001260| 68 65 20 73 65 61 72 63 | 68 2e 20 52 75 6e 20 44 |he searc|h. Run D|
|00001270| 50 45 58 50 2f 44 50 49 | 4d 50 2e 20 20 52 65 73 |PEXP/DPI|MP. Res|
|00001280| 65 74 20 74 68 65 20 73 | 65 61 72 63 68 20 63 6f |et the s|earch co|
|00001290| 6e 64 69 74 69 6f 6e 73 | 20 62 65 66 6f 72 65 20 |nditions| before |
|000012a0| 72 75 6e 6e 69 6e 67 20 | 74 68 65 20 72 65 70 6f |running |the repo|
|000012b0| 72 74 20 61 67 61 69 6e | 2e 00 69 66 20 28 63 6f |rt again|..if (co|
|000012c0| 06 00 a2 00 a0 53 74 61 | 63 6b 20 64 65 70 74 68 |.....Sta|ck depth|
|000012d0| 20 65 72 72 6f 72 20 69 | 6e 20 74 68 65 20 74 65 | error i|n the te|
|000012e0| 78 74 20 65 64 69 74 6f | 72 2e 20 20 54 68 65 72 |xt edito|r. Ther|
|000012f0| 65 20 6d 61 79 20 62 65 | 20 61 20 70 72 6f 62 6c |e may be| a probl|
|00001300| 65 6d 20 69 6e 20 74 68 | 65 20 74 65 78 74 20 65 |em in th|e text e|
|00001310| 64 69 74 6f 72 2e 20 20 | 49 66 20 74 68 65 20 65 |ditor. |If the e|
|00001320| 72 72 6f 72 20 63 61 6e | 20 62 65 20 64 75 70 6c |rror can| be dupl|
|00001330| 69 63 61 74 65 64 2c 20 | 69 74 20 73 68 6f 75 6c |icated, |it shoul|
|00001340| 64 20 62 65 20 72 65 70 | 6f 72 74 65 64 20 74 6f |d be rep|orted to|
|00001350| 20 44 61 74 61 50 65 72 | 66 65 63 74 20 53 75 70 | DataPer|fect Sup|
|00001360| 70 6f 72 74 2e 00 00 00 | 00 6d 00 00 63 22 20 20 |port....|.m..c" |
|00001370| 65 6e 64 6f 66 ff 33 63 | 61 73 65 20 63 6f 6e 74 |endof.3c|ase cont|
|00001380| 06 00 43 04 17 45 78 70 | 6f 72 74 2f 49 6d 70 6f |..C..Exp|ort/Impo|
|00001390| 72 74 20 74 68 65 20 64 | 61 74 61 2e ff 3e 4d 41 |rt the d|ata..>MA|
|000013a0| 4b 45 20 53 55 52 45 20 | 59 4f 55 20 48 41 56 45 |KE SURE |YOU HAVE|
|000013b0| 20 41 20 42 41 43 4b 55 | 50 20 4f 46 20 59 4f 55 | A BACKU|P OF YOU|
|000013c0| 52 20 44 41 54 41 42 41 | 53 45 20 42 45 46 4f 52 |R DATABA|SE BEFOR|
|000013d0| 45 20 4d 41 4b 49 4e 47 | 20 41 4e 59 ff 0e 4d 4f |E MAKING| ANY..MO|
|000013e0| 44 49 46 49 43 41 54 49 | 4f 4e 53 2e ff 34 49 66 |DIFICATI|ONS..4If|
|000013f0| 20 79 6f 75 20 63 61 6e | 27 74 20 67 65 74 20 69 | you can|'t get i|
|00001400| 6e 74 6f 20 74 68 65 20 | 70 61 6e 65 6c 2c 20 66 |nto the |panel, f|
|00001410| 6f 6c 6c 6f 77 20 74 68 | 65 73 65 20 73 74 65 70 |ollow th|ese step|
|00001420| 73 3a ff 33 31 2e 20 20 | 20 44 65 6c 65 74 65 20 |s:.31. | Delete |
|00001430| 74 68 65 20 2e 49 4e 44 | 20 66 69 6c 65 20 66 6f |the .IND| file fo|
|00001440| 72 20 74 68 61 74 20 64 | 61 74 61 62 61 73 65 20 |r that d|atabase |
|00001450| 61 74 20 44 4f 53 2e ff | 40 32 2e 20 20 20 47 6f |at DOS..|@2. Go|
|00001460| 20 69 6e 74 6f 20 44 61 | 74 61 50 65 72 66 65 63 | into Da|taPerfec|
|00001470| 74 20 61 6e 64 20 70 72 | 65 73 73 20 45 6e 74 65 |t and pr|ess Ente|
|00001480| 72 20 74 6f 20 61 63 63 | 65 73 73 20 74 68 65 20 |r to acc|ess the |
|00001490| 64 61 74 61 62 61 73 65 | 2e ff 57 33 2e 20 20 20 |database|..W3. |
|000014a0| 57 68 65 6e 20 67 69 76 | 65 6e 20 74 68 65 20 22 |When giv|en the "|
|000014b0| 49 4e 44 20 66 69 6c 65 | 20 69 73 20 6e 6f 74 20 |IND file| is not |
|000014c0| 66 6f 75 6e 64 2e 2e 2e | 2e 22 20 6d 65 73 73 61 |found...|." messa|
|000014d0| 67 65 2c 20 70 72 65 73 | 73 20 31 20 74 6f 20 63 |ge, pres|s 1 to c|
|000014e0| 72 65 61 74 65 20 6e 65 | 77 20 69 6e 64 65 78 65 |reate ne|w indexe|
|000014f0| 73 2e ff 4e 34 2e 20 20 | 20 41 74 20 74 68 65 20 |s..N4. | At the |
|00001500| 6c 69 73 74 20 6f 66 20 | 70 61 6e 65 6c 73 2c 20 |list of |panels, |
|00001510| 70 72 65 73 73 20 45 6e | 74 65 72 20 77 69 74 68 |press En|ter with|
|00001520| 20 74 68 65 20 66 69 72 | 73 74 20 70 61 6e 65 6c | the fir|st panel|
|00001530| 20 6e 61 6d 65 20 68 69 | 67 68 6c 69 67 68 74 65 | name hi|ghlighte|
|00001540| 64 2e ff f7 35 2e 20 20 | 20 41 20 77 61 72 6e 69 |d...5. | A warni|
|00001550| 6e 67 20 77 69 6c 6c 20 | 61 70 70 65 61 72 2c 20 |ng will |appear, |
|00001560| 73 61 79 69 6e 67 20 74 | 68 65 72 65 20 61 72 65 |saying t|here are|
|00001570| 20 6e 6f 20 69 6e 64 65 | 78 65 73 2c 20 62 75 74 | no inde|xes, but|
|00001580| 20 61 20 66 69 6c 65 20 | 68 61 73 20 62 65 65 6e | a file |has been|
|00001590| 20 66 6f 75 6e 64 20 77 | 68 69 63 68 20 63 6f 6e | found w|hich con|
|000015a0| 74 61 69 6e 73 20 64 61 | 74 61 2e 20 20 50 72 65 |tains da|ta. Pre|
|000015b0| 73 73 20 6f 70 74 69 6f | 6e 20 34 20 28 65 76 65 |ss optio|n 4 (eve|
|000015c0| 6e 20 69 66 20 69 74 27 | 73 20 6e 6f 74 20 64 69 |n if it'|s not di|
|000015d0| 73 70 6c 61 79 65 64 29 | 2e 20 20 54 68 69 73 20 |splayed)|. This |
|000015e0| 6f 70 74 69 6f 6e 20 6c | 65 74 73 20 79 6f 75 20 |option l|ets you |
|000015f0| 65 78 70 6f 72 74 20 64 | 61 74 61 20 77 69 74 68 |export d|ata with|
|00001600| 6f 75 74 20 75 73 69 6e | 67 20 69 6e 64 65 78 65 |out usin|g indexe|
|00001610| 73 2e 20 20 59 6f 75 27 | 6c 6c 20 62 65 20 74 61 |s. You'|ll be ta|
|00001620| 6b 65 6e 20 74 6f 20 74 | 68 65 20 6c 69 73 74 20 |ken to t|he list |
|00001630| 6f 66 20 72 65 70 6f 72 | 74 73 2e ff e7 36 2e 20 |of repor|ts...6. |
|00001640| 20 50 6c 61 63 65 20 79 | 6f 75 72 20 63 75 72 73 | Place y|our curs|
|00001650| 6f 72 20 6f 6e 20 42 75 | 69 6c 74 2d 49 6e 20 53 |or on Bu|ilt-In S|
|00001660| 68 6f 72 74 20 52 65 70 | 6f 72 74 73 20 61 6e 64 |hort Rep|orts and|
|00001670| 20 70 72 65 73 73 20 45 | 6e 74 65 72 20 74 6f 20 | press E|nter to |
|00001680| 65 78 70 6f 72 74 20 79 | 6f 75 72 20 64 61 74 61 |export y|our data|
|00001690| 2e 20 20 4d 41 4b 45 20 | 53 55 52 45 20 49 54 27 |. MAKE |SURE IT'|
|000016a0| 53 20 42 45 49 4e 47 20 | 45 58 50 4f 52 54 45 44 |S BEING |EXPORTED|
|000016b0| 20 49 4e 20 41 20 46 4f | 52 4d 41 54 20 54 48 41 | IN A FO|RMAT THA|
|000016c0| 54 20 43 41 4e 20 42 45 | 20 52 45 2d 49 4d 50 4f |T CAN BE| RE-IMPO|
|000016d0| 52 54 45 44 20 28 6f 70 | 74 69 6f 6e 20 38 29 2c |RTED (op|tion 8),|
|000016e0| 20 61 6e 64 20 74 68 61 | 74 20 79 6f 75 27 72 65 | and tha|t you're|
|000016f0| 20 65 78 70 6f 72 74 69 | 6e 67 20 61 6c 6c 20 72 | exporti|ng all r|
|00001700| 65 61 6c 20 66 69 65 6c | 64 73 2c 20 69 6e 63 6c |eal fiel|ds, incl|
|00001710| 75 64 69 6e 67 20 68 69 | 64 64 65 6e 20 66 69 65 |uding hi|dden fie|
|00001720| 6c 64 73 2e ff 34 37 2e | 20 20 52 65 70 65 61 74 |lds..47.| Repeat|
|00001730| 20 73 74 65 70 73 20 34 | 2d 36 20 66 6f 72 20 65 | steps 4|-6 for e|
|00001740| 61 63 68 20 70 61 6e 65 | 6c 20 69 6e 20 74 68 65 |ach pane|l in the|
|00001750| 20 64 61 74 61 62 61 73 | 65 2e ff 34 38 2e 20 20 | databas|e..48. |
|00001760| 44 65 6c 65 74 65 20 74 | 68 65 20 72 65 63 6f 72 |Delete t|he recor|
|00001770| 64 73 20 66 72 6f 6d 20 | 65 61 63 68 20 70 61 6e |ds from |each pan|
|00001780| 65 6c 20 28 41 6c 74 2d | 46 35 2c 31 2c 79 29 2e |el (Alt-|F5,1,y).|
|00001790| ff 34 39 2e 20 20 49 6d | 70 6f 72 74 20 74 68 65 |.49. Im|port the|
|000017a0| 20 64 61 74 61 20 62 61 | 63 6b 20 69 6e 74 6f 20 | data ba|ck into |
|000017b0| 65 61 63 68 20 70 61 6e | 65 6c 2e 20 28 43 74 72 |each pan|el. (Ctr|
|000017c0| 6c 2d 46 35 29 2e 00 73 | 65 20 74 68 65 73 65 20 |l-F5)..s|e these |
|000017d0| 73 74 65 70 73 20 74 6f | 20 63 6f 6e 64 69 74 69 |steps to| conditi|
|000017e0| 23 00 f2 00 f0 54 6f 20 | 63 6f 72 72 65 63 74 20 |#....To |correct |
|000017f0| 74 68 69 73 2c 20 64 65 | 6c 65 74 65 20 74 68 65 |this, de|lete the|
|00001800| 20 70 61 6e 65 6c 20 66 | 69 6c 65 20 74 68 61 74 | panel f|ile that|
|00001810| 20 74 68 65 20 64 61 74 | 61 20 77 61 73 20 69 6d | the dat|a was im|
|00001820| 70 6f 72 74 65 64 20 69 | 6e 74 6f 2c 20 72 65 74 |ported i|nto, ret|
|00001830| 72 69 65 76 65 20 74 68 | 65 20 6d 65 72 67 65 20 |rieve th|e merge |
|00001840| 66 69 6c 65 20 69 6e 20 | 57 6f 72 64 50 65 72 66 |file in |WordPerf|
|00001850| 65 63 74 2c 20 74 68 65 | 6e 20 73 61 76 65 20 69 |ect, the|n save i|
|00001860| 74 20 61 73 20 61 20 57 | 50 20 34 2e 32 20 66 69 |t as a W|P 4.2 fi|
|00001870| 6c 65 20 28 43 74 72 6c | 2d 46 35 2c 20 33 2c 20 |le (Ctrl|-F5, 3, |
|00001880| 33 20 69 6e 20 57 50 35 | 31 20 61 6e 64 20 43 74 |3 in WP5|1 and Ct|
|00001890| 72 6c 2d 46 35 2c 20 34 | 20 69 6e 20 57 50 35 30 |rl-F5, 4| in WP50|
|000018a0| 29 2e 20 20 54 68 69 73 | 20 66 69 6c 65 20 63 61 |). This| file ca|
|000018b0| 6e 20 74 68 65 6e 20 62 | 65 20 69 6d 70 6f 72 74 |n then b|e import|
|000018c0| 65 64 20 77 69 74 68 6f | 75 74 20 74 68 65 20 65 |ed witho|ut the e|
|000018d0| 72 72 6f 72 2e 00 68 65 | 6d 2e 20 20 20 54 68 65 |rror..he|m. The|
|000018e0| 08 00 b0 00 ae 42 75 66 | 66 65 72 20 65 72 72 6f |.....Buf|fer erro|
|000018f0| 72 20 77 68 69 6c 65 20 | 73 61 76 69 6e 67 20 74 |r while |saving t|
|00001900| 65 78 74 20 66 6f 72 20 | 74 68 65 20 74 65 78 74 |ext for |the text|
|00001910| 20 65 64 69 74 6f 72 2e | 20 20 54 68 65 72 65 20 | editor.| There |
|00001920| 6d 61 79 20 62 65 20 61 | 20 70 72 6f 62 6c 65 6d |may be a| problem|
|00001930| 20 69 6e 20 74 68 65 20 | 74 65 78 74 20 65 64 69 | in the |text edi|
|00001940| 74 6f 72 2e 20 20 49 66 | 20 74 68 65 20 65 72 72 |tor. If| the err|
|00001950| 6f 72 20 63 61 6e 20 62 | 65 20 64 75 70 6c 69 63 |or can b|e duplic|
|00001960| 61 74 65 64 2c 20 69 74 | 20 73 68 6f 75 6c 64 20 |ated, it| should |
|00001970| 62 65 20 72 65 70 6f 72 | 74 65 64 20 74 6f 20 44 |be repor|ted to D|
|00001980| 61 74 61 50 65 72 66 65 | 63 74 20 53 75 70 70 6f |ataPerfe|ct Suppo|
|00001990| 72 74 2e 00 6e 63 61 74 | 65 64 2c 20 61 6e 64 20 |rt..ncat|ed, and |
|000019a0| 06 00 30 00 2e 53 65 65 | 20 53 6f 6c 75 74 69 6f |..0..See| Solutio|
|000019b0| 6e 73 20 61 6e 64 20 54 | 72 6f 75 62 6c 65 73 68 |ns and T|roublesh|
|000019c0| 6f 6f 74 69 6e 67 20 66 | 6f 72 20 45 72 72 6f 72 |ooting f|or Error|
|000019d0| 20 32 2e 00 65 72 74 20 | 64 61 74 65 20 74 65 78 | 2..ert |date tex|
|000019e0| 02 00 b2 00 b0 53 65 71 | 75 65 6e 63 65 20 65 72 |.....Seq|uence er|
|000019f0| 72 6f 72 20 77 68 69 6c | 65 20 73 61 76 69 6e 67 |ror whil|e saving|
|00001a00| 20 74 65 78 74 20 66 6f | 72 20 74 68 65 20 74 65 | text fo|r the te|
|00001a10| 78 74 20 65 64 69 74 6f | 72 2e 20 20 54 68 65 72 |xt edito|r. Ther|
|00001a20| 65 20 6d 61 79 20 62 65 | 20 61 20 70 72 6f 62 6c |e may be| a probl|
|00001a30| 65 6d 20 69 6e 20 74 68 | 65 20 74 65 78 74 20 65 |em in th|e text e|
|00001a40| 64 69 74 6f 72 2e 20 20 | 49 66 20 74 68 65 20 65 |ditor. |If the e|
|00001a50| 72 72 6f 72 20 63 61 6e | 20 62 65 20 64 75 70 6c |rror can| be dupl|
|00001a60| 69 63 61 74 65 64 2c 20 | 69 74 20 73 68 6f 75 6c |icated, |it shoul|
|00001a70| 64 20 62 65 20 72 65 70 | 6f 72 74 65 64 20 74 6f |d be rep|orted to|
|00001a80| 20 44 61 74 61 50 65 72 | 66 65 63 74 20 53 75 70 | DataPer|fect Sup|
|00001a90| 70 6f 72 74 2e 00 31 39 | 2f 31 39 39 32 2e 20 20 |port..19|/1992. |
|00001aa0| 06 00 36 00 34 53 65 65 | 20 53 6f 6c 75 74 69 6f |..6.4See| Solutio|
|00001ab0| 6e 73 20 61 6e 64 20 54 | 72 6f 75 62 6c 65 73 68 |ns and T|roublesh|
|00001ac0| 6f 6f 74 69 6e 67 20 53 | 74 65 70 73 20 66 6f 72 |ooting S|teps for|
|00001ad0| 20 45 72 72 6f 72 20 32 | 2e 00 32 2e 20 20 4f 70 | Error 2|..2. Op|
|00001ae0| 02 00 34 00 32 73 75 62 | 73 74 72 69 6e 67 5b 61 |..4.2sub|string[a|
|00001af0| 70 70 6c 79 2e 66 6f 72 | 6d 61 74 5b 22 4e 28 39 |pply.for|mat["N(9|
|00001b00| 39 39 29 39 39 39 2d 39 | 39 39 39 22 3b 50 23 46 |99)999-9|999";P#F|
|00001b10| 23 5d 3b 32 3b 33 5d 00 | 6c 6c 20 61 73 73 75 6d |#];2;3].|ll assum|
|00001b20| 02 00 a2 00 1a 50 23 46 | 23 20 3d 20 50 68 6f 6e |.....P#F|# = Phon|
|00001b30| 65 20 4e 75 6d 62 65 72 | 20 46 69 65 6c 64 2e ff |e Number| Field..|
|00001b40| ff 83 54 68 69 73 20 66 | 6f 72 6d 75 6c 61 20 63 |..This f|ormula c|
|00001b50| 6f 6e 76 65 72 74 73 20 | 61 20 6e 75 6d 65 72 69 |onverts |a numeri|
|00001b60| 63 20 66 69 65 6c 64 20 | 74 6f 20 74 65 78 74 20 |c field |to text |
|00001b70| 75 73 69 6e 67 20 61 70 | 70 6c 79 2e 66 6f 72 6d |using ap|ply.form|
|00001b80| 61 74 20 61 6e 64 20 74 | 68 65 6e 20 65 78 74 72 |at and t|hen extr|
|00001b90| 61 63 74 73 20 74 68 65 | 20 61 72 65 61 20 63 6f |acts the| area co|
|00001ba0| 64 65 20 6f 6e 6c 79 20 | 75 73 69 6e 67 20 74 68 |de only |using th|
|00001bb0| 65 20 73 75 62 73 74 72 | 69 6e 67 20 66 75 6e 63 |e substr|ing func|
|00001bc0| 74 69 6f 6e 2e 00 6e 73 | 5b 63 76 3b 22 67 72 6f |tion..ns|[cv;"gro|
|00001bd0| 75 70 2f 77 63 22 5d 20 | 20 20 6f 66 20 22 67 72 |up/wc"] | of "gr|
|00001be0| 06 00 4a 02 17 50 23 46 | 23 20 3d 20 66 69 65 6c |..J..P#F|# = fiel|
|00001bf0| 64 20 74 6f 20 73 65 61 | 72 63 68 2e ff 24 72 76 |d to sea|rch..$rv|
|00001c00| 23 20 20 3d 20 72 65 70 | 6f 72 74 20 76 61 72 69 |# = rep|ort vari|
|00001c10| 61 62 6c 65 20 70 72 6f | 6d 70 74 65 64 20 66 6f |able pro|mpted fo|
|00001c20| 72 2e ff ff fd 43 72 65 | 61 74 65 20 61 20 70 72 |r....Cre|ate a pr|
|00001c30| 6f 6d 70 74 20 66 6f 72 | 20 72 65 70 6f 72 74 20 |ompt for| report |
|00001c40| 76 61 72 69 61 62 6c 65 | 20 74 68 61 74 20 72 65 |variable| that re|
|00001c50| 71 75 65 73 74 73 20 61 | 20 76 61 6c 75 65 20 74 |quests a| value t|
|00001c60| 6f 20 73 65 61 72 63 68 | 20 66 6f 72 20 6f 72 20 |o search| for or |
|00001c70| 61 6e 20 61 73 74 65 72 | 69 73 6b 20 28 2a 29 20 |an aster|isk (*) |
|00001c80| 66 6f 72 20 61 6c 6c 20 | 72 65 63 6f 72 64 73 2e |for all |records.|
|00001c90| 20 20 49 66 20 61 20 6c | 69 74 65 72 61 6c 20 76 | If a l|iteral v|
|00001ca0| 61 6c 75 65 20 69 73 20 | 65 6e 74 65 72 65 64 20 |alue is |entered |
|00001cb0| 74 68 65 6e 20 44 61 74 | 61 50 65 72 66 65 63 74 |then Dat|aPerfect|
|00001cc0| 20 77 69 6c 6c 20 72 65 | 74 75 72 6e 20 61 6c 6c | will re|turn all|
|00001cd0| 20 6d 61 74 63 68 69 6e | 67 20 72 65 63 6f 72 64 | matchin|g record|
|00001ce0| 73 2c 20 62 75 74 20 69 | 66 20 61 6e 20 61 73 74 |s, but i|f an ast|
|00001cf0| 65 72 69 73 6b 20 69 73 | 20 65 6e 74 65 72 65 64 |erisk is| entered|
|00001d00| 20 74 68 65 6e 20 61 6c | 6c 20 72 65 63 6f 72 64 | then al|l record|
|00001d10| 73 20 77 69 6c 6c 20 62 | 65 20 70 72 69 6e 74 65 |s will b|e printe|
|00001d20| 64 2e ff ff fd 44 6f 20 | 6e 6f 74 20 75 73 65 20 |d....Do |not use |
|00001d30| 61 20 66 6f 72 6d 75 6c | 61 20 74 68 61 74 20 72 |a formul|a that r|
|00001d40| 65 61 64 73 20 50 23 46 | 23 3d 52 56 23 20 69 6e |eads P#F|#=RV# in|
|00001d50| 73 74 65 61 64 20 6f 66 | 20 74 68 65 20 63 6f 6e |stead of| the con|
|00001d60| 74 61 69 6e 73 20 66 75 | 6e 63 74 69 6f 6e 20 61 |tains fu|nction a|
|00001d70| 73 20 44 61 74 61 50 65 | 72 66 65 63 74 20 77 69 |s DataPe|rfect wi|
|00001d80| 6c 6c 20 74 68 65 6e 20 | 6c 6f 6f 6b 20 66 6f 72 |ll then |look for|
|00001d90| 20 61 6e 20 61 73 74 65 | 72 69 73 6b 20 69 6e 20 | an aste|risk in |
|00001da0| 74 68 65 20 66 69 65 6c | 64 20 63 6f 6e 74 65 6e |the fiel|d conten|
|00001db0| 74 73 2e 20 20 55 73 69 | 6e 67 20 74 68 65 20 63 |ts. Usi|ng the c|
|00001dc0| 6f 6e 74 61 69 6e 73 5b | 50 23 46 23 3b 72 76 23 |ontains[|P#F#;rv#|
|00001dd0| 5d 20 74 65 6c 6c 73 20 | 74 68 65 20 72 65 70 6f |] tells |the repo|
|00001de0| 72 74 20 74 6f 20 63 6f | 6e 73 69 64 65 72 20 74 |rt to co|nsider t|
|00001df0| 68 65 20 61 73 74 65 72 | 69 73 6b 20 61 20 77 69 |he aster|isk a wi|
|00001e00| 6c 64 63 61 72 64 3b 20 | 61 6e 64 2c 20 74 68 65 |ldcard; |and, the|
|00001e10| 72 65 66 6f 72 65 2c 20 | 74 6f 20 66 69 6e 64 20 |refore, |to find |
|00001e20| 61 6c 0a 6c 20 72 65 63 | 6f 72 64 73 2e 00 20 20 |al.l rec|ords.. |
|00001e30| 65 6e 64 6f 66 ff 33 63 | 61 73 65 20 63 6f 6e 74 |endof.3c|ase cont|
|00001e40| 13 00 7b 02 1b 69 66 20 | 50 23 46 23 20 3d 20 22 |..{..if |P#F# = "|
|00001e50| 20 22 20 74 68 65 6e 20 | 22 20 22 20 65 6c 73 65 | " then |" " else|
|00001e60| ff 23 69 66 20 28 73 75 | 62 73 74 72 69 6e 67 5b |.#if (su|bstring[|
|00001e70| 50 23 46 23 3b 31 3b 31 | 5d 20 3e 3d 20 22 41 22 |P#F#;1;1|] >= "A"|
|00001e80| 20 20 61 6e 64 ff 24 20 | 20 20 20 73 75 62 73 74 | and.$ | subst|
|00001e90| 72 69 6e 67 5b 50 23 46 | 23 3b 31 3b 31 5d 20 3c |ring[P#F|#;1;1] <|
|00001ea0| 3d 20 22 5a 22 29 20 74 | 68 65 6e ff 23 69 66 20 |= "Z") t|hen.#if |
|00001eb0| 28 73 75 62 73 74 72 69 | 6e 67 5b 50 23 46 23 3b |(substri|ng[P#F#;|
|00001ec0| 32 3b 31 5d 20 3e 3d 20 | 22 30 22 20 20 61 6e 64 |2;1] >= |"0" and|
|00001ed0| ff 24 20 20 20 20 73 75 | 62 73 74 72 69 6e 67 5b |.$ su|bstring[|
|00001ee0| 50 23 46 23 3b 32 3b 31 | 5d 20 3c 3d 20 22 39 22 |P#F#;2;1|] <= "9"|
|00001ef0| 29 20 74 68 65 6e ff 23 | 69 66 20 28 73 75 62 73 |) then.#|if (subs|
|00001f00| 74 72 69 6e 67 5b 50 23 | 46 23 3b 33 3b 31 5d 20 |tring[P#|F#;3;1] |
|00001f10| 3e 3d 20 22 41 22 20 20 | 61 6e 64 ff 24 20 20 20 |>= "A" |and.$ |
|00001f20| 20 73 75 62 73 74 72 69 | 6e 67 5b 50 23 46 23 3b | substri|ng[P#F#;|
|00001f30| 33 3b 31 5d 20 3c 3d 20 | 22 5a 22 29 20 74 68 65 |3;1] <= |"Z") the|
|00001f40| 6e ff 24 69 66 20 28 73 | 75 62 73 74 72 69 6e 67 |n.$if (s|ubstring|
|00001f50| 5b 50 23 46 23 3b 34 3b | 31 5d 20 3d 20 22 20 22 |[P#F#;4;|1] = " "|
|00001f60| 29 20 20 74 68 65 6e ff | 23 69 66 20 28 73 75 62 |) then.|#if (sub|
|00001f70| 73 74 72 69 6e 67 5b 50 | 23 46 23 3b 35 3b 31 5d |string[P|#F#;5;1]|
|00001f80| 20 3e 3d 20 22 30 22 20 | 20 61 6e 64 ff 24 20 20 | >= "0" | and.$ |
|00001f90| 20 20 73 75 62 73 74 72 | 69 6e 67 5b 50 23 46 23 | substr|ing[P#F#|
|00001fa0| 3b 35 3b 31 5d 20 3c 3d | 20 22 39 22 29 20 74 68 |;5;1] <=| "9") th|
|00001fb0| 65 6e ff 23 69 66 20 28 | 73 75 62 73 74 72 69 6e |en.#if (|substrin|
|00001fc0| 67 5b 50 23 46 23 3b 36 | 3b 31 5d 20 3e 3d 20 22 |g[P#F#;6|;1] >= "|
|00001fd0| 41 22 20 20 61 6e 64 ff | 24 20 20 20 20 73 75 62 |A" and.|$ sub|
|00001fe0| 73 74 72 69 6e 67 5b 50 | 23 46 23 3b 36 3b 31 5d |string[P|#F#;6;1]|
|00001ff0| 20 3c 3d 20 22 5a 22 29 | 20 74 68 65 6e ff 23 69 | <= "Z")| then.#i|
|00002000| 66 20 28 73 75 62 73 74 | 72 69 6e 67 5b 50 23 46 |f (subst|ring[P#F|
|00002010| 23 3b 37 3b 31 5d 20 3e | 3d 20 22 30 22 20 20 61 |#;7;1] >|= "0" a|
|00002020| 6e 64 ff 29 20 20 20 20 | 73 75 62 73 74 72 69 6e |nd.) |substrin|
|00002030| 67 5b 50 23 46 23 3b 37 | 3b 31 5d 20 3c 3d 20 22 |g[P#F#;7|;1] <= "|
|00002040| 39 22 29 20 74 68 65 6e | 20 50 23 46 23 ff 3b 65 |9") then| P#F#.;e|
|00002050| 6c 73 65 20 22 20 22 20 | 65 6e 64 69 66 20 65 6c |lse " " |endif el|
|00002060| 73 65 20 22 20 22 20 65 | 6e 64 69 66 20 65 6c 73 |se " " e|ndif els|
|00002070| 65 20 22 20 22 20 65 6e | 64 69 66 20 65 6c 73 65 |e " " en|dif else|
|00002080| 20 22 20 22 20 65 6e 64 | 69 66 ff 32 65 6c 73 65 | " " end|if.2else|
|00002090| 20 22 20 22 20 65 6e 64 | 69 66 20 65 6c 73 65 20 | " " end|if else |
|000020a0| 22 20 22 20 65 6e 64 69 | 66 20 65 6c 73 65 20 22 |" " endi|f else "|
|000020b0| 20 22 20 65 6e 64 69 66 | 20 65 6e 64 69 66 00 67 | " endif| endif.g|
|000020c0| 14 00 00 00 0b 00 00 00 | 00 00 00 00 50 6f 73 74 |........|....Post|
|000020d0| 61 6c 20 63 6f 64 65 20 | 66 69 65 6c 64 2e ff fd |al code |field...|
|000020e0| 54 68 69 73 20 66 6f 72 | 6d 75 6c 61 20 69 73 20 |This for|mula is |
|000020f0| 64 65 73 69 67 6e 65 64 | 20 74 6f 20 63 68 65 63 |designed| to chec|
|00002100| 6b 20 74 68 65 20 64 61 | 74 61 20 65 6e 74 65 72 |k the da|ta enter|
|00002110| 65 64 20 69 6e 20 61 20 | 43 61 6e 61 64 69 61 6e |ed in a |Canadian|
|00002120| 20 70 6f 73 74 61 6c 20 | 63 6f 64 65 20 66 69 65 | postal |code fie|
|00002130| 6c 64 2e 20 20 49 74 20 | 63 6f 6e 66 69 72 6d 73 |ld. It |confirms|
|00002140| 20 74 68 61 74 20 74 68 | 65 20 63 6f 72 72 65 63 | that th|e correc|
|00002150| 74 20 73 65 71 75 65 6e | 63 65 20 6f 66 20 63 68 |t sequen|ce of ch|
|00002160| 61 72 61 63 74 65 72 73 | 20 69 73 20 65 6e 74 65 |aracters| is ente|
|00002170| 72 65 64 20 69 6e 20 74 | 68 65 20 66 69 65 6c 64 |red in t|he field|
|00002180| 2e 20 20 28 49 65 2e 20 | 41 23 41 20 23 41 23 20 |. (Ie. |A#A #A# |
|00002190| 77 68 65 72 65 20 41 20 | 3d 20 61 6e 20 61 6c 70 |where A |= an alp|
|000021a0| 68 61 20 63 68 61 72 61 | 63 74 65 72 20 61 6e 64 |ha chara|cter and|
|000021b0| 20 23 20 65 71 75 61 6c | 73 20 61 20 6e 75 6d 65 | # equal|s a nume|
|000021c0| 72 69 63 20 76 61 6c 75 | 65 2e 20 20 4e 6f 74 69 |ric valu|e. Noti|
|000021d0| 63 65 20 74 68 61 74 20 | 74 68 65 72 65 36 20 69 |ce that |there6 i|
|000021e0| 73 20 61 20 73 70 61 63 | 65 20 62 65 74 77 65 65 |s a spac|e betwee|
|000021f0| 6e 20 74 68 65 20 74 77 | 6f 20 73 65 74 73 20 6f |n the tw|o sets o|
|00002200| 66 20 74 68 72 65 65 20 | 63 68 61 72 61 63 74 65 |f three |characte|
|00002210| 72 73 2e 29 00 20 73 79 | 6d 62 6f 6c 73 20 6f 72 |rs.). sy|mbols or|
|00002220| 0b 00 63 03 1e 63 61 74 | 2e 74 5b 61 70 70 6c 79 |..c..cat|.t[apply|
|00002230| 2e 66 6f 72 6d 61 74 5b | 22 55 31 22 3b 50 23 46 |.format[|"U1";P#F|
|00002240| 23 5d 3b ff 38 20 20 20 | 20 20 20 73 75 62 73 74 |#];.8 | subst|
|00002250| 72 69 6e 67 5b 50 23 46 | 23 3b 32 3b 6c 65 6e 67 |ring[P#F|#;2;leng|
|00002260| 74 68 5b 73 75 62 66 69 | 65 6c 64 5b 50 23 46 23 |th[subfi|eld[P#F#|
|00002270| 3b 22 20 22 3b 31 5d 5d | 5d 3b 22 20 22 ff ff 2e |;" ";1]]|];" "...|
|00002280| 20 20 20 20 20 20 61 70 | 70 6c 79 2e 66 6f 72 6d | ap|ply.form|
|00002290| 61 74 5b 22 55 31 22 3b | 73 75 62 66 69 65 6c 64 |at["U1";|subfield|
|000022a0| 5b 50 23 46 23 3b 22 20 | 22 3b 32 5d 5d 3b ff 48 |[P#F#;" |";2]];.H|
|000022b0| 20 20 20 20 20 20 73 75 | 62 73 74 72 69 6e 67 5b | su|bstring[|
|000022c0| 73 75 62 66 69 65 6c 64 | 5b 50 23 46 23 3b 22 20 |subfield|[P#F#;" |
|000022d0| 22 3b 32 5d 3b 32 3b 6c | 65 6e 67 74 68 5b 73 75 |";2];2;l|ength[su|
|000022e0| 62 66 69 65 6c 64 5b 50 | 23 46 23 3b 22 20 22 3b |bfield[P|#F#;" ";|
|000022f0| 32 5d 5d 5d 3b 22 20 22 | ff ff 2e 20 20 20 20 20 |2]]];" "|... |
|00002300| 20 61 70 70 6c 79 2e 66 | 6f 72 6d 61 74 5b 22 55 | apply.f|ormat["U|
|00002310| 31 22 3b 73 75 62 66 69 | 65 6c 64 5b 50 23 46 23 |1";subfi|eld[P#F#|
|00002320| 3b 22 20 22 3b 33 5d 5d | 3b ff 48 20 20 20 20 20 |;" ";3]]|;.H |
|00002330| 20 73 75 62 73 74 72 69 | 6e 67 5b 73 75 62 66 69 | substri|ng[subfi|
|00002340| 65 6c 64 5b 50 23 46 23 | 3b 22 20 22 3b 33 5d 3b |eld[P#F#|;" ";3];|
|00002350| 32 3b 6c 65 6e 67 74 68 | 5b 73 75 62 66 69 65 6c |2;length|[subfiel|
|00002360| 64 5b 50 23 46 23 3b 22 | 20 22 3b 33 5d 5d 5d 3b |d[P#F#;"| ";3]]];|
|00002370| 22 20 22 ff ff 2e 20 20 | 20 20 20 20 61 70 70 6c |" "... | appl|
|00002380| 79 2e 66 6f 72 6d 61 74 | 5b 22 55 31 22 3b 73 75 |y.format|["U1";su|
|00002390| 62 66 69 65 6c 64 5b 50 | 23 46 23 3b 22 20 22 3b |bfield[P|#F#;" ";|
|000023a0| 34 5d 5d 3b ff 48 20 20 | 20 20 20 20 73 75 62 73 |4]];.H | subs|
|000023b0| 74 72 69 6e 67 5b 73 75 | 62 66 69 65 6c 64 5b 50 |tring[su|bfield[P|
|000023c0| 23 46 23 3b 22 20 22 3b | 34 5d 3b 32 3b 6c 65 6e |#F#;" ";|4];2;len|
|000023d0| 67 74 68 5b 73 75 62 66 | 69 65 6c 64 5b 50 23 46 |gth[subf|ield[P#F|
|000023e0| 23 3b 22 20 22 3b 34 5d | 5d 5d 3b 22 20 22 ff ff |#;" ";4]|]];" "..|
|000023f0| 2e 20 20 20 20 20 20 61 | 70 70 6c 79 2e 66 6f 72 |. a|pply.for|
|00002400| 6d 61 74 5b 22 55 31 22 | 3b 73 75 62 66 69 65 6c |mat["U1"|;subfiel|
|00002410| 64 5b 50 23 46 23 3b 22 | 20 22 3b 35 5d 5d 3b ff |d[P#F#;"| ";5]];.|
|00002420| 48 20 20 20 20 20 20 73 | 75 62 73 74 72 69 6e 67 |H s|ubstring|
|00002430| 5b 73 75 62 66 69 65 6c | 64 5b 50 23 46 23 3b 22 |[subfiel|d[P#F#;"|
|00002440| 20 22 3b 35 5d 3b 32 3b | 6c 65 6e 67 74 68 5b 73 | ";5];2;|length[s|
|00002450| 75 62 66 69 65 6c 64 5b | 50 23 46 23 3b 22 20 22 |ubfield[|P#F#;" "|
|00002460| 3b 35 5d 5d 5d 22 20 22 | 3b ff ff 35 20 20 20 20 |;5]]]" "|;..5 |
|00002470| 20 20 73 75 62 73 74 72 | 69 6e 67 5b 50 23 46 23 | substr|ing[P#F#|
|00002480| 3b 28 28 6c 65 6e 67 74 | 68 5b 73 75 62 66 69 65 |;((lengt|h[subfie|
|00002490| 6c 64 5b 50 23 46 23 3b | 22 20 22 3b 31 5d 5d 20 |ld[P#F#;|" ";1]] |
|000024a0| 2b ff 35 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |+.5 | |
|000024b0| 20 20 20 20 20 20 20 20 | 20 20 6c 65 6e 67 74 68 | | length|
|000024c0| 5b 73 75 62 66 69 65 6c | 64 5b 50 23 46 23 3b 22 |[subfiel|d[P#F#;"|
|000024d0| 20 22 3b 32 5d 5d 20 2b | ff 35 20 20 20 20 20 20 | ";2]] +|.5 |
|000024e0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000024f0| 20 6c 65 6e 67 74 68 5b | 73 75 62 66 69 65 6c 64 | length[|subfield|
|00002500| 5b 50 23 46 23 3b 22 20 | 22 3b 33 5d 5d 20 2b ff |[P#F#;" |";3]] +.|
|00002510| 35 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |5 | |
|00002520| 20 20 20 20 20 20 20 20 | 6c 65 6e 67 74 68 5b 73 | |length[s|
|00002530| 75 62 66 69 65 6c 64 5b | 50 23 46 23 3b 22 20 22 |ubfield[|P#F#;" "|
|00002540| 3b 34 5d 5d 20 2b ff 3e | 20 20 20 20 20 20 20 20 |;4]] +.>| |
|00002550| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 6c | | l|
|00002560| 65 6e 67 74 68 5b 73 75 | 62 66 69 65 6c 64 5b 50 |ength[su|bfield[P|
|00002570| 23 46 23 3b 22 20 22 3b | 35 5d 5d 29 20 2b 20 35 |#F#;" ";|5]]) + 5|
|00002580| 29 3b 34 30 5d 5d 00 00 | 00 6d 00 00 66 22 20 65 |);40]]..|.m..f" e|
|00002590| 6e 64 20 62 65 66 6f 72 | 65 20 74 68 65 20 64 6f |nd befor|e the do|
|000025a0| 1c 00 72 01 11 50 23 46 | 23 20 3d 20 41 34 30 20 |..r..P#F|# = A40 |
|000025b0| 66 69 65 6c 64 2e ff ff | d1 54 68 69 73 20 66 6f |field...|.This fo|
|000025c0| 72 6d 75 6c 61 20 69 73 | 20 75 73 65 64 20 69 6e |rmula is| used in|
|000025d0| 20 61 20 72 65 70 6f 72 | 74 20 76 61 72 69 61 62 | a repor|t variab|
|000025e0| 6c 65 20 69 6e 20 74 68 | 65 20 72 65 70 6f 72 74 |le in th|e report|
|000025f0| 20 62 6f 64 79 20 6f 66 | 20 61 20 72 65 70 6f 72 | body of| a repor|
|00002600| 74 2e 20 20 49 74 20 69 | 73 20 75 73 65 64 20 74 |t. It i|s used t|
|00002610| 6f 20 63 6f 72 72 65 63 | 74 20 64 61 74 61 20 74 |o correc|t data t|
|00002620| 68 61 74 20 68 61 73 20 | 62 65 65 6e 20 69 6e 63 |hat has |been inc|
|00002630| 6f 72 72 65 63 74 6c 79 | 20 65 6e 74 65 72 65 64 |orrectly| entered|
|00002640| 20 62 79 20 61 64 64 69 | 6e 67 20 62 6c 61 6e 6b | by addi|ng blank|
|00002650| 73 20 74 6f 20 74 68 65 | 20 62 65 67 69 6e 6e 69 |s to the| beginni|
|00002660| 6e 67 20 6f 66 20 61 20 | 73 74 72 69 6e 67 2e 20 |ng of a |string. |
|00002670| 20 54 68 65 20 66 6f 72 | 6d 75 6c 61 20 73 69 6d | The for|mula sim|
|00002680| 70 6c 79 20 74 61 6b 65 | 73 20 42 74 68 65 20 73 |ply take|s Bthe s|
|00002690| 74 72 69 6e 67 20 69 6e | 20 50 31 46 31 20 61 6e |tring in| P1F1 an|
|000026a0| 64 20 74 72 75 6e 63 61 | 74 65 73 20 61 6e 64 20 |d trunca|tes and |
|000026b0| 6c 65 61 64 69 6e 67 20 | 62 6c 61 6e 6b 73 2e 20 |leading |blanks. |
|000026c0| 20 54 68 69 73 20 72 65 | 70 6f 72 74 20 47 76 61 | This re|port Gva|
|000026d0| 72 69 61 62 6c 65 20 73 | 68 6f 75 6c 64 20 74 68 |riable s|hould th|
|000026e0| 65 6e 20 62 65 20 73 74 | 6f 72 65 64 20 62 61 63 |en be st|ored bac|
|000026f0| 6b 20 69 6e 74 6f 20 74 | 68 65 20 66 69 65 6c 64 |k into t|he field|
|00002700| 20 66 72 6f 6d 20 77 68 | 65 6e 63 65 20 69 74 20 | from wh|ence it |
|00002710| 63 61 6d 65 2e 00 72 65 | 20 74 68 65 20 66 69 6e |came..re| the fin|
|00002720| 0c 00 00 00 0d 00 e1 02 | 00 00 00 00 20 66 75 6e |........|.... fun|
|00002730| 63 74 69 6f 6e 20 73 65 | 74 29 20 74 68 61 74 20 |ction se|t) that |
|00002740| 69 73 20 73 65 70 65 72 | 61 74 65 64 20 62 79 20 |is seper|ated by |
|00002750| 62 6c 61 6e 6b 20 6c 69 | 6e 65 73 20 69 6e 20 74 |blank li|nes in t|
|00002760| 68 65 20 66 6f 72 6d 75 | 6c 61 20 61 62 6f 76 65 |he formu|la above|
|00002770| 20 6d 61 6b 69 6e 67 20 | 73 75 72 65 20 74 6f 20 | making |sure to |
|00002780| 61 64 64 20 6f 6e 65 20 | 74 6f 20 74 68 65 20 74 |add one |to the t|
|00002790| 68 69 72 64 20 61 72 67 | 75 6d 65 6e 74 20 69 6e |hird arg|ument in|
|000027a0| 20 74 68 65 20 73 75 62 | 66 69 65 6c 64 20 66 75 | the sub|field fu|
|000027b0| 6e 63 74 69 6f 6e 73 20 | 74 6f 20 69 6e 64 69 63 |nctions |to indic|
|000027c0| 61 74 65 20 77 68 69 63 | 68 20 77 6f 72 64 20 a4 |ate whic|h word .|
|000027d0| 69 73 20 62 65 69 6e 67 | 20 63 68 61 6e 67 65 64 |is being| changed|
|000027e0| 2c 20 63 68 61 6e 67 65 | 20 74 68 65 20 6c 61 73 |, change| the las|
|000027f0| 74 20 6c 69 6e 65 20 6f | 66 20 74 68 65 20 61 62 |t line o|f the ab|
|00002800| 6f 76 65 20 66 6f 72 6d | 75 6c 61 20 74 6f 20 72 |ove form|ula to r|
|00002810| 65 61 64 20 22 2b 20 23 | 22 20 77 68 65 72 65 20 |ead "+ #|" where |
|00002820| 23 20 65 71 75 61 6c 73 | 20 74 68 65 20 6e 75 6d |# equals| the num|
|00002830| 62 65 72 20 6f 66 20 77 | 6f 72 64 73 20 74 68 61 |ber of w|ords tha|
|00002840| 74 20 79 6f 75 20 61 72 | 65 20 63 68 61 6e 67 69 |t you ar|e changi|
|00002850| 6e 67 20 61 6e 64 20 22 | 34 30 22 20 65 71 75 61 |ng and "|40" equa|
|00002860| 6c 73 20 74 68 65 20 66 | 69 65 6c 64 20 6c 65 6e |ls the f|ield len|
|00002870| 67 74 68 2e 00 18 20 20 | 20 59 45 41 52 5b 50 33 |gth... | YEAR[P3|
|00002880| 0b 00 2d 00 2b 61 70 70 | 6c 79 2e 66 6f 72 6d 61 |..-.+app|ly.forma|
|00002890| 74 5b 22 55 31 22 3b 50 | 23 46 23 5d 73 75 62 73 |t["U1";P|#F#]subs|
|000028a0| 74 72 69 6e 67 5b 50 23 | 46 23 3b 32 3b 32 39 5d |tring[P#|F#;2;29]|
|000028b0| 00 20 77 69 6c 6c 20 63 | 61 6c 63 75 6c 61 74 65 |. will c|alculate|
|000028c0| 0d 00 67 01 10 50 23 46 | 23 20 3d 20 41 33 30 20 |..g..P#F|# = A30 |
|000028d0| 66 69 65 6c 64 ff ff fd | 54 68 69 73 20 66 6f 72 |field...|This for|
|000028e0| 6d 75 6c 61 20 63 68 61 | 6e 67 65 73 20 74 68 65 |mula cha|nges the|
|000028f0| 20 66 69 72 73 74 20 6c | 65 74 74 65 72 20 74 6f | first l|etter to|
|00002900| 20 75 70 70 65 72 63 61 | 73 65 20 61 6e 64 20 74 | upperca|se and t|
|00002910| 68 65 6e 20 61 70 70 65 | 6e 64 73 20 74 68 65 20 |hen appe|nds the |
|00002920| 72 65 73 74 20 6f 66 20 | 74 68 65 20 66 69 65 6c |rest of |the fiel|
|00002930| 64 20 63 6f 6e 74 65 6e | 74 73 2e 20 20 54 68 65 |d conten|ts. The|
|00002940| 20 66 69 72 73 74 20 6c | 65 74 74 65 72 2c 20 69 | first l|etter, i|
|00002950| 66 20 69 74 20 69 73 20 | 6e 6f 74 20 61 6c 72 65 |f it is |not alre|
|00002960| 61 64 79 20 75 70 70 65 | 72 63 61 73 65 2c 20 77 |ady uppe|rcase, w|
|00002970| 69 6c 6c 20 6e 6f 74 20 | 62 65 63 6f 6d 65 20 75 |ill not |become u|
|00002980| 70 70 65 72 63 61 73 65 | 20 75 6e 74 69 6c 20 5b |ppercase| until [|
|00002990| 54 61 62 5d 20 69 73 20 | 70 72 65 73 73 65 64 20 |Tab] is |pressed |
|000029a0| 74 6f 20 6d 6f 76 65 20 | 6f 66 66 20 74 68 65 20 |to move |off the |
|000029b0| 63 75 72 72 65 6e 74 20 | 66 69 65 6c 64 20 28 6e |current |field (n|
|000029c0| 75 6d 62 65 72 73 20 77 | 69 6c 6c 20 62 65 20 75 |umbers w|ill be u|
|000029d0| 6e 63 68 61 6e 54 67 65 | 64 29 2e 20 20 41 72 67 |nchanTge|d). Arg|
|000029e0| 33 20 69 6e 20 74 68 65 | 20 73 75 62 73 74 72 69 |3 in the| substri|
|000029f0| 6e 67 20 63 6f 64 65 20 | 73 68 6f 75 6c 64 20 62 |ng code |should b|
|00002a00| 65 20 65 71 75 61 6c 20 | 74 6f 20 6f 6e 65 20 6c |e equal |to one l|
|00002a10| 65 73 73 20 74 68 61 6e | 20 74 68 65 20 66 69 65 |ess than| the fie|
|00002a20| 6c 64 20 6c 65 6e 67 74 | 68 2e 00 56 31 20 61 6e |ld lengt|h..V1 an|
|00002a30| 64 20 52 56 32 20 61 72 | 65 20 62 6f 74 68 20 70 |d RV2 ar|e both p|
|00002a40| 0c 00 99 01 fd 54 6f 20 | 63 6f 6e 64 69 74 69 6f |.....To |conditio|
|00002a50| 6e 61 6c 6c 79 20 70 72 | 69 6e 74 20 70 61 72 74 |nally pr|int part|
|00002a60| 73 20 6f 66 20 61 20 6e | 61 6d 65 20 28 69 2e 65 |s of a n|ame (i.e|
|00002a70| 2e 20 73 61 6c 75 74 61 | 74 69 6f 6e 2c 20 66 69 |. saluta|tion, fi|
|00002a80| 72 73 74 2c 20 6d 69 64 | 64 6c 65 2c 20 61 6e 64 |rst, mid|dle, and|
|00002a90| 20 6c 61 73 74 20 6e 61 | 6d 65 2c 20 65 74 63 2e | last na|me, etc.|
|00002aa0| 2e 2e 29 20 73 65 6c 65 | 63 74 20 74 68 65 20 66 |..) sele|ct the f|
|00002ab0| 69 65 6c 64 73 20 61 73 | 20 79 6f 75 20 6e 6f 72 |ields as| you nor|
|00002ac0| 6d 61 6c 6c 79 20 64 6f | 20 69 6e 20 61 20 72 65 |mally do| in a re|
|00002ad0| 70 6f 72 74 2c 20 77 69 | 74 68 6f 75 74 20 70 75 |port, wi|thout pu|
|00002ae0| 74 74 69 6e 67 20 73 70 | 61 63 65 73 20 62 65 74 |tting sp|aces bet|
|00002af0| 77 65 65 6e 20 74 68 65 | 6d 2e 20 20 20 54 68 65 |ween the|m. The|
|00002b00| 6e 20 65 64 69 74 20 65 | 61 63 68 20 6f 66 20 74 |n edit e|ach of t|
|00002b10| 68 65 20 66 69 65 6c 64 | 20 66 6f 72 6d 61 74 73 |he field| formats|
|00002b20| 2c 20 61 64 64 69 6e 67 | 20 61 20 3b 3b 31 20 74 |, adding| a ;;1 t|
|00002b30| 6f 20 74 68 65 20 65 6e | 64 20 6f 66 20 65 61 63 |o the en|d of eac|
|00002b40| 68 2e 99 20 20 54 68 65 | 20 3b 3b 31 20 70 75 74 |h.. The| ;;1 put|
|00002b50| 73 20 61 20 73 70 61 63 | 65 20 62 65 74 77 65 65 |s a spac|e betwee|
|00002b60| 6e 20 65 61 63 68 20 66 | 69 65 6c 64 2c 20 69 66 |n each f|ield, if|
|00002b70| 20 74 68 65 20 66 69 65 | 6c 64 20 65 78 69 73 74 | the fie|ld exist|
|00002b80| 73 2e 20 20 49 66 20 69 | 74 20 64 6f 65 73 6e 27 |s. If i|t doesn'|
|00002b90| 74 20 65 78 69 73 74 2c | 20 74 68 65 20 66 69 65 |t exist,| the fie|
|00002ba0| 6c 64 20 69 73 20 63 6f | 6d 70 6c 65 74 65 6c 79 |ld is co|mpletely|
|00002bb0| 20 74 72 75 6e 63 61 74 | 65 64 2c 20 61 6e 64 20 | truncat|ed, and |
|00002bc0| 6e 6f 20 65 78 74 72 61 | 20 73 70 61 63 65 73 20 |no extra| spaces |
|00002bd0| 61 72 65 20 70 72 69 6e | 74 65 64 2e 00 21 20 20 |are prin|ted..! |
|00002be0| 0d 00 9b 03 0a 50 23 46 | 23 20 63 61 73 65 73 ff |.....P#F|# cases.|
|00002bf0| 33 63 61 73 65 20 63 6f | 6e 74 61 69 6e 73 5b 63 |3case co|ntains[c|
|00002c00| 76 3b 22 67 72 6f 75 70 | 22 5d 20 20 20 20 20 20 |v;"group|"] |
|00002c10| 6f 66 20 22 67 72 6f 75 | 70 22 20 20 20 20 20 65 |of "grou|p" e|
|00002c20| 6e 64 6f 66 ff 33 63 61 | 73 65 20 63 6f 6e 74 61 |ndof.3ca|se conta|
|00002c30| 69 6e 73 5b 63 76 3b 22 | 67 72 6f 75 70 2f 70 69 |ins[cv;"|group/pi|
|00002c40| 70 22 5d 20 20 6f 66 20 | 22 67 72 6f 75 70 2f 70 |p"] of |"group/p|
|00002c50| 69 70 22 20 65 6e 64 6f | 66 ff 33 63 61 73 65 20 |ip" endo|f.3case |
|00002c60| 63 6f 6e 74 61 69 6e 73 | 5b 63 76 3b 22 67 72 6f |contains|[cv;"gro|
|00002c70| 75 70 2f 77 63 22 5d 20 | 20 20 6f 66 20 22 67 72 |up/wc"] | of "gr|
|00002c80| 6f 75 70 2f 77 63 22 20 | 20 65 6e 64 6f 66 ff 33 |oup/wc" | endof.3|
|00002c90| 63 61 73 65 20 63 6f 6e | 74 61 69 6e 73 5b 63 76 |case con|tains[cv|
|00002ca0| 3b 22 70 69 70 22 5d 20 | 20 20 20 20 20 20 20 6f |;"pip"] | o|
|00002cb0| 66 20 22 70 69 70 22 20 | 20 20 20 20 20 20 65 6e |f "pip" | en|
|00002cc0| 64 6f 66 ff 33 63 61 73 | 65 20 63 6f 6e 74 61 69 |dof.3cas|e contai|
|00002cd0| 6e 73 5b 63 76 3b 22 77 | 63 22 5d 20 20 20 20 20 |ns[cv;"w|c"] |
|00002ce0| 20 20 20 20 6f 66 20 22 | 77 63 22 20 20 20 20 20 | of "|wc" |
|00002cf0| 20 20 20 65 6e 64 6f 66 | ff 33 63 61 73 65 20 63 | endof|.3case c|
|00002d00| 6f 6e 74 61 69 6e 73 5b | 63 76 3b 22 31 22 5d 20 |ontains[|cv;"1"] |
|00002d10| 20 20 20 20 20 20 20 20 | 20 6f 66 20 22 67 72 6f | | of "gro|
|00002d20| 75 70 22 20 20 20 20 20 | 65 6e 64 6f 66 ff 33 63 |up" |endof.3c|
|00002d30| 61 73 65 20 63 6f 6e 74 | 61 69 6e 73 5b 63 76 3b |ase cont|ains[cv;|
|00002d40| 22 32 22 5d 20 20 20 20 | 20 20 20 20 20 20 6f 66 |"2"] | of|
|00002d50| 20 22 67 72 6f 75 70 2f | 70 69 70 22 20 65 6e 64 | "group/|pip" end|
|00002d60| 6f 66 ff 33 63 61 73 65 | 20 63 6f 6e 74 61 69 6e |of.3case| contain|
|00002d70| 73 5b 63 76 3b 22 33 22 | 5d 20 20 20 20 20 20 20 |s[cv;"3"|] |
|00002d80| 20 20 20 6f 66 20 22 67 | 72 6f 75 70 2f 77 63 22 | of "g|roup/wc"|
|00002d90| 20 20 65 6e 64 6f 66 ff | 33 63 61 73 65 20 63 6f | endof.|3case co|
|00002da0| 6e 74 61 69 6e 73 5b 63 | 76 3b 22 34 22 5d 20 20 |ntains[c|v;"4"] |
|00002db0| 20 20 20 20 20 20 20 20 | 6f 66 20 22 70 69 70 22 | |of "pip"|
|00002dc0| 20 20 20 20 20 20 20 65 | 6e 64 6f 66 ff 33 63 61 | e|ndof.3ca|
|00002dd0| 73 65 20 63 6f 6e 74 61 | 69 6e 73 5b 63 76 3b 22 |se conta|ins[cv;"|
|00002de0| 35 22 5d 20 20 20 20 20 | 20 20 20 20 20 6f 66 20 |5"] | of |
|00002df0| 22 70 69 70 2f 77 63 22 | 20 20 20 20 65 6e 64 6f |"pip/wc"| endo|
|00002e00| 66 ff 33 63 61 73 65 20 | 63 6f 6e 74 61 69 6e 73 |f.3case |contains|
|00002e10| 5b 63 76 3b 22 36 22 5d | 20 20 20 20 20 20 20 20 |[cv;"6"]| |
|00002e20| 20 20 6f 66 20 22 77 63 | 22 20 20 20 20 20 20 20 | of "wc|" |
|00002e30| 20 65 6e 64 6f 66 ff 33 | 63 61 73 65 20 63 6f 6e | endof.3|case con|
|00002e40| 74 61 69 6e 73 5b 63 76 | 3b 22 67 22 5d 20 20 20 |tains[cv|;"g"] |
|00002e50| 20 20 20 20 20 20 20 6f | 66 20 22 67 72 6f 75 70 | o|f "group|
|00002e60| 22 20 20 20 20 20 65 6e | 64 6f 66 ff 33 63 61 73 |" en|dof.3cas|
|00002e70| 65 20 63 6f 6e 74 61 69 | 6e 73 5b 63 76 3b 22 67 |e contai|ns[cv;"g|
|00002e80| 70 22 5d 20 20 20 20 20 | 20 20 20 20 6f 66 20 22 |p"] | of "|
|00002e90| 67 72 6f 75 70 2f 70 69 | 70 22 20 65 6e 64 6f 66 |group/pi|p" endof|
|00002ea0| ff 33 63 61 73 65 20 63 | 6f 6e 74 61 69 6e 73 5b |.3case c|ontains[|
|00002eb0| 63 76 3b 22 67 77 22 5d | 20 20 20 20 20 20 20 20 |cv;"gw"]| |
|00002ec0| 20 6f 66 20 22 67 72 6f | 75 70 2f 77 63 22 20 20 | of "gro|up/wc" |
|00002ed0| 65 6e 64 6f 66 ff 33 63 | 61 73 65 20 63 6f 6e 74 |endof.3c|ase cont|
|00002ee0| 61 69 6e 73 5b 63 76 3b | 22 70 22 5d 20 20 20 20 |ains[cv;|"p"] |
|00002ef0| 20 20 20 20 20 20 6f 66 | 20 22 70 69 70 22 20 20 | of| "pip" |
|00002f00| 20 20 20 20 20 65 6e 64 | 6f 66 ff 33 63 61 73 65 | end|of.3case|
|00002f10| 20 63 6f 6e 74 61 69 6e | 73 5b 63 76 3b 22 70 77 | contain|s[cv;"pw|
|00002f20| 22 5d 20 20 20 20 20 20 | 20 20 20 6f 66 20 22 70 |"] | of "p|
|00002f30| 69 70 2f 77 63 22 20 20 | 20 20 65 6e 64 6f 66 ff |ip/wc" | endof.|
|00002f40| 33 63 61 73 65 20 63 6f | 6e 74 61 69 6e 73 5b 63 |3case co|ntains[c|
|00002f50| 76 3b 22 77 22 5d 20 20 | 20 20 20 20 20 20 20 20 |v;"w"] | |
|00002f60| 6f 66 20 22 77 63 22 20 | 20 20 20 20 20 20 20 65 |of "wc" | e|
|00002f70| 6e 64 6f 66 ff 08 65 6e | 64 63 61 73 65 73 00 2e |ndof..en|dcases..|
|00002f80| 1d 00 6b 00 69 54 68 69 | 73 20 66 6f 72 6d 75 6c |..k.iThi|s formul|
|00002f90| 61 20 61 6c 6c 6f 77 73 | 20 74 68 65 20 75 73 65 |a allows| the use|
|00002fa0| 72 20 74 6f 20 65 6e 74 | 65 72 20 74 68 65 20 73 |r to ent|er the s|
|00002fb0| 61 6d 65 20 64 61 74 61 | 20 69 6e 74 6f 20 61 20 |ame data| into a |
|00002fc0| 66 69 65 6c 64 20 75 73 | 69 6e 67 20 64 69 66 66 |field us|ing diff|
|00002fd0| 65 72 65 6e 74 20 73 79 | 6d 62 6f 6c 73 20 6f 72 |erent sy|mbols or|
|00002fe0| 20 61 62 62 72 65 76 69 | 61 74 69 6f 6e 73 00 72 | abbrevi|ations.r|
|00002ff0| 74 2c 20 6d 6f 76 65 20 | 74 68 65 20 63 75 72 73 |t, move |the curs|
|00003000| 04 00 b1 00 22 69 66 20 | 28 6d 6f 6e 74 68 5b 74 |...."if |(month[t|
|00003010| 6f 64 61 79 5d 20 2b 20 | 3c 23 23 3e 29 20 3c 20 |oday] + |<##>) < |
|00003020| 31 33 20 74 68 65 6e ff | 38 20 20 64 61 74 65 5b |13 then.|8 date[|
|00003030| 64 61 79 5b 74 6f 64 61 | 79 5d 3b 28 6d 6f 6e 74 |day[toda|y];(mont|
|00003040| 68 5b 74 6f 64 61 79 5d | 20 2b 20 3c 6e 75 6d 62 |h[today]| + <numb|
|00003050| 65 72 3e 29 3b 79 65 61 | 72 5b 74 6f 64 61 79 5d |er>);yea|r[today]|
|00003060| 5d ff 04 65 6c 73 65 ff | 44 20 20 64 61 74 65 5b |]..else.|D date[|
|00003070| 64 61 79 5b 74 6f 64 61 | 79 5d 3b 28 28 6d 6f 6e |day[toda|y];((mon|
|00003080| 74 68 5b 74 6f 64 61 79 | 5d 20 2b 20 3c 6e 75 6d |th[today|] + <num|
|00003090| 62 65 72 3e 29 20 2f 2f | 20 31 32 29 3b 79 65 61 |ber>) //| 12);yea|
|000030a0| 72 5b 74 6f 64 61 79 5d | 20 2b 20 31 5d ff 05 65 |r[today]| + 1]..e|
|000030b0| 6e 64 69 66 00 2c 20 77 | 68 69 63 68 20 69 73 20 |ndif., w|hich is |
|000030c0| 06 00 e9 00 23 74 6f 64 | 61 79 20 3d 20 74 68 65 |....#tod|ay = the|
|000030d0| 20 64 61 74 65 20 76 61 | 6c 75 65 20 74 6f 20 61 | date va|lue to a|
|000030e0| 64 64 20 6f 6e 74 6f 2e | ff 37 3c 23 23 3e 20 3d |dd onto.|.7<##> =|
|000030f0| 20 74 68 65 20 6e 75 6d | 62 65 72 20 6f 66 20 6d | the num|ber of m|
|00003100| 6f 6e 74 68 73 20 74 6f | 20 61 64 64 20 6f 6e 74 |onths to| add ont|
|00003110| 6f 20 74 68 65 20 64 61 | 74 65 20 76 61 6c 75 65 |o the da|te value|
|00003120| 2e ff ff 88 45 78 61 6d | 70 6c 65 3a 20 55 73 69 |....Exam|ple: Usi|
|00003130| 6e 67 20 36 20 61 73 20 | 74 68 65 20 6e 75 6d 62 |ng 6 as |the numb|
|00003140| 65 72 20 77 6f 75 6c 64 | 20 63 68 61 6e 67 65 20 |er would| change |
|00003150| 61 20 74 6f 64 61 79 20 | 76 61 6c 75 65 20 6f 66 |a today |value of|
|00003160| 20 30 35 2f 31 39 2f 39 | 32 20 74 6f 20 31 31 2f | 05/19/9|2 to 11/|
|00003170| 31 39 2f 39 32 20 61 6e | 64 20 77 6f 75 6c 64 20 |19/92 an|d would |
|00003180| 63 68 61 6e 67 65 20 61 | 20 74 6f 64 61 79 20 76 |change a| today v|
|00003190| 61 6c 75 65 20 6f 66 20 | 31 31 2f 31 39 2f 39 32 |alue of |11/19/92|
|000031a0| 20 74 6f 20 35 2f 31 39 | 2f 39 33 2e 00 52 49 4e | to 5/19|/93..RIN|
|000031b0| 47 5b 50 31 46 31 3b 31 | 3b 31 5d 20 54 48 45 4e |G[P1F1;1|;1] THEN|
|000031c0| 08 00 2e 00 2c 20 61 70 | 70 6c 79 2e 66 6f 72 6d |...., ap|ply.form|
|000031d0| 61 74 5b 22 55 31 22 3b | 50 23 46 23 5d 73 75 62 |at["U1";|P#F#]sub|
|000031e0| 73 74 72 69 6e 67 5b 50 | 23 46 23 3b 32 3b 32 39 |string[P|#F#;2;29|
|000031f0| 5d 00 68 65 72 20 6e 75 | 6d 65 72 69 63 20 66 69 |].her nu|meric fi|
|00003200| 02 00 24 00 22 6c 6e 5b | 31 31 5d 20 72 65 74 75 |..$."ln[|11] retu|
|00003210| 72 6e 73 20 32 2e 34 20 | 28 61 70 70 72 6f 78 69 |rns 2.4 |(approxi|
|00003220| 6d 61 74 65 6c 79 29 00 | 65 74 65 72 6d 69 6e 65 |mately).|etermine|
|00003230| 20 61 67 65 20 74 6f 20 | 74 68 65 20 65 78 61 63 | age to |the exac|
|00003240| 02 00 00 00 01 00 d1 01 | 00 2b 05 00 73 20 65 6d |........|.+..s em|
|00003250| 70 74 79 2e 20 20 49 66 | 20 74 68 65 20 74 65 78 |pty. If| the tex|
|00003260| 01 00 73 00 22 69 66 20 | 6d 6f 6e 74 68 5b 74 6f |..s."if |month[to|
|00003270| 64 61 79 5d 20 3e 20 6d | 6f 6e 74 68 5b 50 23 46 |day] > m|onth[P#F|
|00003280| 23 5d 20 74 68 65 6e ff | 1c 20 20 28 79 65 61 72 |#] then.|. (year|
|00003290| 5b 74 6f 64 61 79 5d 20 | 2d 20 79 65 61 72 5b 50 |[today] |- year[P|
|000032a0| 23 46 23 5d 29 ff 04 65 | 6c 73 65 ff 22 20 20 28 |#F#])..e|lse." (|
|000032b0| 28 79 65 61 72 5b 74 6f | 64 61 79 5d 20 2d 20 79 |(year[to|day] - y|
|000032c0| 65 61 72 5b 50 23 46 23 | 5d 29 20 2d 20 31 29 ff |ear[P#F#|]) - 1).|
|000032d0| 05 65 6e 64 69 66 00 20 | 54 48 45 4e ff 29 20 20 |.endif. |THEN.) |
|000032e0| 04 00 90 00 11 50 23 46 | 23 20 3d 20 64 61 74 65 |.....P#F|# = date|
|000032f0| 20 66 69 65 6c 64 ff ff | 7a 55 73 65 64 20 74 6f | field..|zUsed to|
|00003300| 20 64 65 74 65 72 6d 69 | 6e 65 20 61 67 65 20 74 | determi|ne age t|
|00003310| 6f 20 74 68 65 20 6d 6f | 6e 74 68 2e 20 20 57 69 |o the mo|nth. Wi|
|00003320| 74 68 20 74 68 69 73 20 | 66 6f 72 6d 75 6c 61 2c |th this |formula,|
|00003330| 20 61 20 70 65 72 73 6f | 6e 20 69 73 20 6e 6f 74 | a perso|n is not|
|00003340| 20 61 6e 6f 74 68 65 72 | 20 79 65 61 72 20 6f 6c | another| year ol|
|00003350| 64 65 72 20 75 6e 74 69 | 6c 20 61 66 74 65 72 20 |der unti|l after |
|00003360| 74 68 65 20 62 69 72 74 | 68 64 61 79 20 6d 6f 6e |the birt|hday mon|
|00003370| 74 68 2e 00 46 69 65 6c | 64 ff 24 50 31 46 31 50 |th..Fiel|d.$P1F1P|
|00003380| 05 00 3d 00 16 50 23 46 | 23 20 3d 20 42 69 72 74 |..=..P#F|# = Birt|
|00003390| 68 64 61 74 65 20 46 69 | 65 6c 64 ff ff 22 55 73 |hdate Fi|eld.."Us|
|000033a0| 65 64 20 74 6f 20 64 65 | 74 65 72 6d 69 6e 65 20 |ed to de|termine |
|000033b0| 61 67 65 20 74 6f 20 74 | 68 65 20 79 65 61 72 2e |age to t|he year.|
|000033c0| 00 64 20 74 6f 20 64 65 | 74 65 72 6d 69 6e 65 20 |.d to de|termine |
|000033d0| 61 67 65 20 74 6f 20 74 | 68 65 20 79 65 61 72 2e |age to t|he year.|
|000033e0| 03 00 00 00 01 00 00 00 | 00 d1 01 00 20 65 6d 70 |........|.... emp|
|000033f0| 74 79 20 52 56 2e 20 20 | 49 66 20 74 68 65 20 72 |ty RV. |If the r|
|00003400| 01 00 aa 00 26 3c 23 23 | 3e 20 3d 20 61 20 6e 75 |....&<##|> = a nu|
|00003410| 6d 65 72 69 63 20 76 61 | 6c 75 65 20 77 69 74 68 |meric va|lue with|
|00003420| 20 61 20 64 65 63 69 6d | 61 6c 2e ff ff 7f 54 68 | a decim|al....Th|
|00003430| 69 73 20 66 6f 72 6d 75 | 6c 61 20 72 65 74 75 72 |is formu|la retur|
|00003440| 6e 73 20 74 68 65 20 64 | 65 63 69 6d 61 6c 20 70 |ns the d|ecimal p|
|00003450| 6f 72 74 69 6f 6e 20 6f | 66 20 74 68 65 20 6e 75 |ortion o|f the nu|
|00003460| 6d 62 65 72 2e 20 20 45 | 78 61 6d 70 6c 65 3a 20 |mber. E|xample: |
|00003470| 49 66 20 3c 23 23 3e 20 | 63 6f 6e 74 61 69 6e 73 |If <##> |contains|
|00003480| 20 74 68 65 20 6e 75 6d | 62 65 72 20 37 2e 35 34 | the num|ber 7.54|
|00003490| 37 36 20 74 68 65 20 66 | 6f 72 6d 75 6c 61 20 72 |76 the f|ormula r|
|000034a0| 65 74 75 72 6e 73 20 2e | 35 34 37 36 2e 00 63 6f |eturns .|5476..co|
|000034b0| 6d 62 69 6e 65 73 20 74 | 68 65 20 79 65 61 72 2c |mbines t|he year,|
|000034c0| 06 00 0c 00 0a 6e 6f 77 | 20 2f 20 33 36 30 30 00 |.....now| / 3600.|
|000034d0| 76 61 6c 75 65 73 20 66 | 72 6f 6d 20 61 20 73 69 |values f|rom a si|
|000034e0| 01 00 3e 00 3c 69 66 20 | 28 79 65 61 72 5b 50 31 |..>.<if |(year[P1|
|000034f0| 46 31 5d 20 2f 2f 20 34 | 30 30 29 20 3d 20 30 20 |F1] // 4|00) = 0 |
|00003500| 74 68 65 6e 20 22 4c 65 | 61 70 22 20 65 6c 73 65 |then "Le|ap" else|
|00003510| 20 22 6e 6f 74 20 4c 65 | 61 70 22 20 65 6e 64 69 | "not Le|ap" endi|
|00003520| 66 00 65 72 20 31 31 2c | 20 31 39 39 32 29 00 64 |f.er 11,| 1992).d|
|00003530| 20 69 6e 20 73 65 63 6f | 6e 64 73 2e 20 20 54 6f | in seco|nds. To|
|00003540| 03 00 ce 02 05 64 61 74 | 65 5b ff 36 69 66 20 28 |.....dat|e[.6if (|
|00003550| 63 6f 6e 76 65 72 74 5b | 22 47 39 39 39 39 22 3b |convert[|"G9999";|
|00003560| 73 75 62 66 69 65 6c 64 | 5b 50 23 46 23 3b 27 20 |subfield|[P#F#;' |
|00003570| 27 3b 32 5d 5d 20 3e 20 | 33 31 29 20 74 68 65 6e |';2]] > |31) then|
|00003580| 20 31 ff 32 20 20 20 65 | 6c 73 65 20 63 6f 6e 76 | 1.2 e|lse conv|
|00003590| 65 72 74 5b 22 47 39 39 | 22 3b 73 75 62 66 69 65 |ert["G99|";subfie|
|000035a0| 6c 64 5b 50 23 46 23 3b | 27 20 27 3b 32 5d 5d 20 |ld[P#F#;|' ';2]] |
|000035b0| 65 6e 64 69 66 3b ff 1a | 73 75 62 66 69 65 6c 64 |endif;..|subfield|
|000035c0| 5b 50 23 46 23 3b 27 20 | 27 3b 31 5d 20 63 61 73 |[P#F#;' |';1] cas|
|000035d0| 65 73 ff 20 63 61 73 65 | 20 63 76 20 3d 20 22 4a |es. case| cv = "J|
|000035e0| 61 6e 75 61 72 79 22 20 | 20 20 6f 66 20 31 20 65 |anuary" | of 1 e|
|000035f0| 6e 64 6f 66 ff 20 63 61 | 73 65 20 63 76 20 3d 20 |ndof. ca|se cv = |
|00003600| 22 46 65 62 75 61 72 79 | 22 20 20 20 6f 66 20 32 |"Febuary|" of 2|
|00003610| 20 65 6e 64 6f 66 ff 20 | 63 61 73 65 20 63 76 20 | endof. |case cv |
|00003620| 3d 20 22 4d 61 72 63 68 | 22 20 20 20 20 20 6f 66 |= "March|" of|
|00003630| 20 33 20 65 6e 64 6f 66 | ff 20 63 61 73 65 20 63 | 3 endof|. case c|
|00003640| 76 20 3d 20 22 41 70 72 | 69 6c 22 20 20 20 20 20 |v = "Apr|il" |
|00003650| 6f 66 20 34 20 65 6e 64 | 6f 66 ff 20 63 61 73 65 |of 4 end|of. case|
|00003660| 20 63 76 20 3d 20 22 4d | 61 79 22 20 20 20 20 20 | cv = "M|ay" |
|00003670| 20 20 6f 66 20 35 20 65 | 6e 64 6f 66 ff 20 63 61 | of 5 e|ndof. ca|
|00003680| 73 65 20 63 76 20 3d 20 | 22 4a 75 6e 65 22 20 20 |se cv = |"June" |
|00003690| 20 20 20 20 6f 66 20 36 | 20 65 6e 64 6f 66 ff 20 | of 6| endof. |
|000036a0| 63 61 73 65 20 63 76 20 | 3d 20 22 4a 75 6c 79 22 |case cv |= "July"|
|000036b0| 20 20 20 20 20 20 6f 66 | 20 37 20 65 6e 64 6f 66 | of| 7 endof|
|000036c0| ff 20 63 61 73 65 20 63 | 76 20 3d 20 22 41 75 67 |. case c|v = "Aug|
|000036d0| 75 73 74 22 20 20 20 20 | 6f 66 20 38 20 65 6e 64 |ust" |of 8 end|
|000036e0| 6f 66 ff 20 63 61 73 65 | 20 63 76 20 3d 20 22 53 |of. case| cv = "S|
|000036f0| 65 70 74 65 6d 62 65 72 | 22 20 6f 66 20 39 20 65 |eptember|" of 9 e|
|00003700| 6e 64 6f 66 ff 21 63 61 | 73 65 20 63 76 20 3d 20 |ndof.!ca|se cv = |
|00003710| 22 4f 63 74 6f 62 65 72 | 22 20 20 20 6f 66 20 31 |"October|" of 1|
|00003720| 30 20 65 6e 64 6f 66 ff | 21 63 61 73 65 20 63 76 |0 endof.|!case cv|
|00003730| 20 3d 20 22 4e 6f 76 65 | 6d 62 65 72 22 20 20 6f | = "Nove|mber" o|
|00003740| 66 20 31 31 20 65 6e 64 | 6f 66 ff 21 63 61 73 65 |f 11 end|of.!case|
|00003750| 20 63 76 20 3d 20 22 44 | 65 63 65 6d 62 65 72 22 | cv = "D|ecember"|
|00003760| 20 20 6f 66 20 31 32 20 | 65 6e 64 6f 66 ff 09 65 | of 12 |endof..e|
|00003770| 6e 64 63 61 73 65 73 3b | ff 34 69 66 20 28 63 6f |ndcases;|.4if (co|
|00003780| 6e 76 65 72 74 5b 22 47 | 39 39 39 39 22 3b 73 75 |nvert["G|9999";su|
|00003790| 62 66 69 65 6c 64 5b 50 | 23 46 23 3b 27 20 27 3b |bfield[P|#F#;' ';|
|000037a0| 32 5d 5d 20 3e 20 33 31 | 29 20 74 68 65 6e ff 29 |2]] > 31|) then.)|
|000037b0| 20 20 20 20 63 6f 6e 76 | 65 72 74 5b 22 47 39 39 | conv|ert["G99|
|000037c0| 39 39 22 3b 73 75 62 66 | 69 65 6c 64 5b 50 23 46 |99";subf|ield[P#F|
|000037d0| 23 3b 27 20 27 3b 32 5d | 5d ff 04 65 6c 73 65 ff |#;' ';2]|]..else.|
|000037e0| 30 20 20 20 20 63 6f 6e | 76 65 72 74 5b 22 47 39 |0 con|vert["G9|
|000037f0| 39 39 39 22 3b 73 75 62 | 66 69 65 6c 64 5b 50 23 |999";sub|field[P#|
|00003800| 46 23 3b 27 20 27 3b 33 | 5d 5d 20 65 6e 64 69 66 |F#;' ';3|]] endif|
|00003810| 5d 00 74 68 61 74 20 73 | 61 6d 65 20 79 65 61 72 |].that s|ame year|
|00003820| 17 00 7a 01 fd 46 6f 72 | 6d 75 6c 61 20 74 6f 20 |..z..For|mula to |
|00003830| 63 6f 6e 76 65 72 74 20 | 64 61 74 65 20 74 65 78 |convert |date tex|
|00003840| 74 20 74 6f 20 64 61 74 | 65 2e 20 54 68 65 20 66 |t to dat|e. The f|
|00003850| 6f 72 6d 75 6c 61 20 77 | 69 6c 6c 20 63 6f 6e 76 |ormula w|ill conv|
|00003860| 65 72 74 20 74 68 65 20 | 64 61 74 65 20 69 6e 20 |ert the |date in |
|00003870| 61 6e 20 61 6c 70 68 61 | 20 66 69 65 6c 64 20 74 |an alpha| field t|
|00003880| 6f 20 61 20 4a 75 6c 69 | 61 6e 20 64 61 74 65 2e |o a Juli|an date.|
|00003890| 20 20 41 20 64 61 74 65 | 20 65 6e 74 65 72 65 64 | A date| entered|
|000038a0| 20 69 6e 20 74 68 65 20 | 61 6c 70 68 61 20 66 69 | in the |alpha fi|
|000038b0| 65 6c 64 20 73 75 63 68 | 20 61 73 20 3a 20 4e 6f |eld such| as : No|
|000038c0| 76 65 6d 62 65 72 20 31 | 39 2c 20 31 39 39 32 20 |vember 1|9, 1992 |
|000038d0| 77 6f 75 6c 64 20 61 70 | 70 65 61 72 20 69 6e 20 |would ap|pear in |
|000038e0| 74 68 65 20 64 61 74 65 | 20 66 69 65 6c 64 20 61 |the date| field a|
|000038f0| 73 20 31 31 2f 31 39 2f | 31 39 39 32 2e 20 20 41 |s 11/19/|1992. A|
|00003900| 20 73 75 62 73 65 74 20 | 6f 66 20 74 68 65 20 6d | subset |of the m|
|00003910| 6f 6e 74 68 20 77 6f 75 | 6c 64 20 61 6c 73 6f 20 |onth wou|ld also |
|00003920| 77 6f 7a 72 6b 2c 20 73 | 75 63 68 20 61 73 20 4e |wozrk, s|uch as N|
|00003930| 6f 76 20 31 39 2c 20 31 | 39 39 32 2e 20 20 4f 70 |ov 19, 1|992. Op|
|00003940| 74 69 6f 6e 61 6c 6c 79 | 2c 20 74 68 65 20 75 73 |tionally|, the us|
|00003950| 65 72 20 6d 61 79 20 65 | 6e 74 65 72 20 4e 6f 76 |er may e|nter Nov|
|00003960| 20 31 39 39 32 20 61 6e | 64 20 74 68 65 20 66 6f | 1992 an|d the fo|
|00003970| 72 6d 75 6c 61 20 77 69 | 6c 6c 20 61 73 73 75 6d |rmula wi|ll assum|
|00003980| 65 20 74 68 65 20 66 69 | 72 73 74 20 64 61 79 20 |e the fi|rst day |
|00003990| 6f 66 20 74 68 65 20 6d | 6f 6e 74 68 2e 00 30 29 |of the m|onth..0)|
|000039a0| 0c 00 74 00 72 54 68 65 | 20 4c 6f 67 61 72 69 74 |..t.rThe| Logarit|
|000039b0| 68 6d 20 66 6f 72 6d 75 | 6c 61 20 66 75 6e 63 74 |hm formu|la funct|
|000039c0| 69 6f 6e 20 28 6c 6e 5b | 78 5d 29 20 72 65 74 75 |ion (ln[|x]) retu|
|000039d0| 72 6e 73 20 74 68 65 20 | 6e 61 74 75 72 61 6c 20 |rns the |natural |
|000039e0| 6c 6f 67 61 72 69 74 68 | 6d 20 6f 66 20 74 68 65 |logarith|m of the|
|000039f0| 20 73 70 65 63 69 66 69 | 65 64 20 6e 75 6d 62 65 | specifi|ed numbe|
|00003a00| 72 20 28 6c 6f 67 20 6f | 66 20 78 20 74 6f 20 62 |r (log o|f x to b|
|00003a10| 61 73 65 20 65 29 2e 00 | 6c 79 2e 66 6f 72 6d 61 |ase e)..|ly.forma|
|00003a20| 04 00 00 00 01 00 9f 01 | 00 92 01 00 50 23 46 23 |........|....P#F#|
|00003a30| 5d 5d 5d 5d 00 56 31 2d | 2d ff 23 20 20 20 69 66 |]]]].V1-|-.# if|
|00003a40| 01 00 d4 00 19 50 23 46 | 23 20 3d 20 44 39 39 2f |.....P#F|# = D99/|
|00003a50| 39 39 2f 39 39 39 39 20 | 66 69 65 6c 64 2e ff ff |99/9999 |field...|
|00003a60| b6 54 68 69 73 20 66 6f | 72 6d 75 6c 61 20 63 6f |.This fo|rmula co|
|00003a70| 6e 63 61 74 65 6e 61 74 | 65 73 20 74 68 65 20 79 |ncatenat|es the y|
|00003a80| 65 61 72 20 28 6f 6e 6c | 79 20 74 68 65 20 6c 61 |ear (onl|y the la|
|00003a90| 73 74 20 74 77 6f 20 64 | 69 67 69 74 73 29 2c 20 |st two d|igits), |
|00003aa0| 6d 6f 6e 74 68 2c 20 61 | 6e 64 20 64 61 79 20 69 |month, a|nd day i|
|00003ab0| 6e 74 6f 20 61 20 6e 75 | 6d 65 72 69 63 20 28 4e |nto a nu|meric (N|
|00003ac0| 39 39 39 39 39 39 29 20 | 66 69 65 6c 64 20 77 69 |999999) |field wi|
|00003ad0| 74 68 20 6e 6f 20 64 61 | 73 68 65 73 20 6f 72 20 |th no da|shes or |
|00003ae0| 68 79 70 68 65 6e 73 2e | 20 20 46 6f 72 20 65 78 |hyphens.| For ex|
|00003af0| 61 6d 70 6c 65 2c 20 31 | 31 2f 31 39 2f 39 32 20 |ample, 1|1/19/92 |
|00003b00| 77 6f 75 6c 64 20 61 70 | 70 65 61 72 20 61 73 20 |would ap|pear as |
|00003b10| 39 32 31 31 31 39 2e 00 | 76 61 69 6c 61 62 6c 65 |921119..|vailable|
|00003b20| 07 00 27 01 45 54 6f 20 | 65 64 69 74 20 61 20 72 |..'.ETo |edit a r|
|00003b30| 65 70 6f 72 74 20 76 61 | 72 69 61 62 6c 65 20 69 |eport va|riable i|
|00003b40| 6e 20 61 20 63 75 73 74 | 6f 6d 20 72 65 70 6f 72 |n a cust|om repor|
|00003b50| 74 2c 20 6d 6f 76 65 20 | 74 68 65 20 63 75 72 73 |t, move |the curs|
|00003b60| 6f 72 20 74 6f 20 74 68 | 65 20 df 6c 69 6e 65 20 |or to th|e .line |
|00003b70| 77 68 65 72 65 20 69 74 | 20 73 61 79 73 20 22 53 |where it| says "S|
|00003b80| 74 6f 72 65 20 56 61 6c | 75 65 20 69 6e 20 52 65 |tore Val|ue in Re|
|00003b90| 70 6f 72 74 20 56 61 72 | 69 61 62 6c 65 20 23 22 |port Var|iable #"|
|00003ba0| 20 61 6e 64 20 70 72 65 | 73 73 20 5b 41 6c 74 2b | and pre|ss [Alt+|
|00003bb0| 46 33 5d 20 28 52 65 76 | 65 61 6c 20 43 6f 64 65 |F3] (Rev|eal Code|
|00003bc0| 73 29 2e 20 20 54 68 65 | 20 66 6f 72 6d 75 6c 61 |s). The| formula|
|00003bd0| 20 77 69 6c 6c 20 74 68 | 65 6e 20 62 65 20 64 69 | will th|en be di|
|00003be0| 73 70 6c 61 79 65 64 20 | 66 6f 72 20 76 69 65 77 |splayed |for view|
|00003bf0| 69 6e 67 20 61 6e 64 20 | 65 64 69 74 69 6e 67 20 |ing and |editing |
|00003c00| 70 75 72 70 6f 73 65 73 | 2e 20 20 44 6f 20 6e 6f |purposes|. Do no|
|00003c10| 74 20 70 72 65 73 73 20 | 5b 46 36 5d 20 28 45 64 |t press |[F6] (Ed|
|00003c20| 69 74 29 20 61 73 20 74 | 68 69 73 20 77 69 6c 6c |it) as t|his will|
|00003c30| 20 74 75 72 6e 20 62 6f | 6c 64 20 6f 6e 20 69 6e | turn bo|ld on in|
|00003c40| 20 61 20 72 65 70 6f 72 | 74 2e 00 20 72 65 63 6f | a repor|t.. reco|
|00003c50| 72 64 73 20 61 72 65 20 | 70 72 69 6e 74 65 64 2e |rds are |printed.|
|00003c60| 0a 00 00 00 28 00 00 00 | 00 6b 02 00 65 20 66 69 |....(...|.k..e fi|
|00003c70| 65 6c 64 73 20 74 68 61 | 74 20 61 72 65 20 74 6f |elds tha|t are to|
|00003c80| 0b 00 40 03 1d 43 41 54 | 2e 43 5b 44 41 59 2e 4f |..@..CAT|.C[DAY.O|
|00003c90| 46 2e 57 45 45 4b 5b 50 | 31 46 31 5d 20 43 41 53 |F.WEEK[P|1F1] CAS|
|00003ca0| 45 53 ff 21 20 20 20 20 | 43 41 53 45 20 43 56 20 |ES.! |CASE CV |
|00003cb0| 3d 20 31 20 4f 46 20 22 | 4d 6f 6e 64 61 79 22 20 |= 1 OF "|Monday" |
|00003cc0| 45 4e 44 4f 46 ff 22 20 | 20 20 20 43 41 53 45 20 |ENDOF." | CASE |
|00003cd0| 43 56 20 3d 20 32 20 4f | 46 20 22 54 75 65 73 64 |CV = 2 O|F "Tuesd|
|00003ce0| 61 79 22 20 45 4e 44 4f | 46 ff 24 20 20 20 20 43 |ay" ENDO|F.$ C|
|00003cf0| 41 53 45 20 43 56 20 3d | 20 33 20 4f 46 20 22 57 |ASE CV =| 3 OF "W|
|00003d00| 65 64 6e 65 73 64 61 79 | 22 20 45 4e 44 4f 46 ff |ednesday|" ENDOF.|
|00003d10| 23 20 20 20 20 43 41 53 | 45 20 43 56 20 3d 20 34 |# CAS|E CV = 4|
|00003d20| 20 4f 46 20 22 54 68 75 | 72 73 64 61 79 22 20 45 | OF "Thu|rsday" E|
|00003d30| 4e 44 4f 46 ff 21 20 20 | 20 20 43 41 53 45 20 43 |NDOF.! | CASE C|
|00003d40| 56 20 3d 20 35 20 4f 46 | 20 22 46 72 69 64 61 79 |V = 5 OF| "Friday|
|00003d50| 22 20 45 4e 44 4f 46 ff | 23 20 20 20 20 43 41 53 |" ENDOF.|# CAS|
|00003d60| 45 20 43 56 20 3d 20 36 | 20 4f 46 20 22 53 61 74 |E CV = 6| OF "Sat|
|00003d70| 75 72 64 61 79 22 20 45 | 4e 44 4f 46 ff 21 20 20 |urday" E|NDOF.! |
|00003d80| 20 20 43 41 53 45 20 43 | 56 20 3d 20 37 20 4f 46 | CASE C|V = 7 OF|
|00003d90| 20 22 53 75 6e 64 61 79 | 22 20 45 4e 44 4f 46 ff | "Sunday|" ENDOF.|
|00003da0| 0f 20 20 45 4e 44 43 41 | 53 45 53 22 2c 20 22 3b |. ENDCA|SES", ";|
|00003db0| ff 12 20 4d 4f 4e 54 48 | 5b 50 31 46 31 5d 20 43 |.. MONTH|[P1F1] C|
|00003dc0| 41 53 45 53 ff 22 20 20 | 20 20 43 41 53 45 20 43 |ASES." | CASE C|
|00003dd0| 56 20 3d 20 31 20 4f 46 | 20 22 4a 61 6e 75 61 72 |V = 1 OF| "Januar|
|00003de0| 79 22 20 45 4e 44 4f 46 | ff 23 20 20 20 20 43 41 |y" ENDOF|.# CA|
|00003df0| 53 45 20 43 56 20 3d 20 | 32 20 4f 46 20 22 46 65 |SE CV = |2 OF "Fe|
|00003e00| 62 72 75 61 72 79 22 20 | 45 4e 44 4f 46 ff 20 20 |bruary" |ENDOF. |
|00003e10| 20 20 20 43 41 53 45 20 | 43 56 20 3d 20 33 20 4f | CASE |CV = 3 O|
|00003e20| 46 20 22 4d 61 72 63 68 | 22 20 45 4e 44 4f 46 ff |F "March|" ENDOF.|
|00003e30| 20 20 20 20 20 43 41 53 | 45 20 43 56 20 3d 20 34 | CAS|E CV = 4|
|00003e40| 20 4f 46 20 22 41 70 72 | 69 6c 22 20 45 4e 44 4f | OF "Apr|il" ENDO|
|00003e50| 46 ff 1e 20 20 20 20 43 | 41 53 45 20 43 56 20 3d |F.. C|ASE CV =|
|00003e60| 20 35 20 4f 46 20 22 4d | 61 79 22 20 45 4e 44 4f | 5 OF "M|ay" ENDO|
|00003e70| 46 ff 1f 20 20 20 20 43 | 41 53 45 20 43 56 20 3d |F.. C|ASE CV =|
|00003e80| 20 36 20 4f 46 20 22 4a | 75 6e 65 22 20 45 4e 44 | 6 OF "J|une" END|
|00003e90| 4f 46 ff 1f 20 20 20 20 | 43 41 53 45 20 43 56 20 |OF.. |CASE CV |
|00003ea0| 3d 20 37 20 4f 46 20 22 | 4a 75 6c 79 22 20 45 4e |= 7 OF "|July" EN|
|00003eb0| 44 4f 46 ff 21 20 20 20 | 20 43 41 53 45 20 43 56 |DOF.! | CASE CV|
|00003ec0| 20 3d 20 38 20 4f 46 20 | 22 41 75 67 75 73 74 22 | = 8 OF |"August"|
|00003ed0| 20 45 4e 44 4f 46 ff 24 | 20 20 20 20 43 41 53 45 | ENDOF.$| CASE|
|00003ee0| 20 43 56 20 3d 20 39 20 | 4f 46 20 22 53 65 70 74 | CV = 9 |OF "Sept|
|00003ef0| 65 6d 62 65 72 22 20 45 | 4e 44 4f 46 ff 23 20 20 |ember" E|NDOF.# |
|00003f00| 20 20 43 41 53 45 20 43 | 56 20 3d 20 31 30 20 4f | CASE C|V = 10 O|
|00003f10| 46 20 22 4f 63 74 6f 62 | 65 72 22 20 45 4e 44 4f |F "Octob|er" ENDO|
|00003f20| 46 ff 24 20 20 20 20 43 | 41 53 45 20 43 56 20 3d |F.$ C|ASE CV =|
|00003f30| 20 31 31 20 4f 46 20 22 | 4e 6f 76 65 6d 62 65 72 | 11 OF "|November|
|00003f40| 22 20 45 4e 44 4f 46 ff | 24 20 20 20 20 43 41 53 |" ENDOF.|$ CAS|
|00003f50| 45 20 43 56 20 3d 20 31 | 32 20 4f 46 20 22 44 65 |E CV = 1|2 OF "De|
|00003f60| 63 65 6d 62 65 72 22 20 | 45 4e 44 4f 46 ff 0b 20 |cember" |ENDOF.. |
|00003f70| 20 45 4e 44 43 41 53 45 | 53 3b ff 23 20 41 50 50 | ENDCASE|S;.# APP|
|00003f80| 4c 59 2e 46 4f 52 4d 41 | 54 5b 22 47 5a 39 22 3b |LY.FORMA|T["GZ9";|
|00003f90| 44 41 59 5b 50 31 46 31 | 5d 5d 22 2c 20 22 3b ff |DAY[P1F1|]]", ";.|
|00003fa0| 22 20 41 50 50 4c 59 2e | 46 4f 52 4d 41 54 5b 22 |" APPLY.|FORMAT["|
|00003fb0| 4e 39 39 39 39 22 3b 59 | 45 41 52 5b 50 31 46 31 |N9999";Y|EAR[P1F1|
|00003fc0| 5d 5d 5d 00 2c 20 69 74 | 20 77 69 6c 6c 20 63 68 |]]]., it| will ch|
|00003fd0| 61 6e 67 65 20 74 6f 20 | 50 4d 2e 20 31 33 30 30 |ange to |PM. 1300|
|00003fe0| 26 00 83 00 11 50 31 46 | 31 20 3d 20 64 61 74 65 |&....P1F|1 = date|
|00003ff0| 20 66 69 65 6c 64 ff 6e | 54 68 69 73 20 66 6f 72 | field.n|This for|
|00004000| 6d 75 6c 61 20 70 72 69 | 6e 74 73 20 74 68 65 20 |mula pri|nts the |
|00004010| 64 61 74 65 20 61 73 20 | 6d 6f 6e 74 68 2c 20 64 |date as |month, d|
|00004020| 61 79 2c 20 79 65 61 72 | 2e 20 20 46 6f 72 20 65 |ay, year|. For e|
|00004030| 78 61 6d 70 6c 65 2c 20 | 31 30 2f 30 31 2f 38 39 |xample, |10/01/89|
|00004040| 20 77 6f 75 6c 64 20 62 | 65 20 70 72 69 6e 74 65 | would b|e printe|
|00004050| 64 20 61 73 20 4f 63 74 | 6f 62 65 72 20 31 30 2c |d as Oct|ober 10,|
|00004060| 20 31 39 38 39 2e 00 68 | 61 74 20 6c 6f 6f 6b 73 | 1989..h|at looks|
|00004070| 20 61 74 20 61 20 66 69 | 65 6c 64 20 66 6f 72 6d | at a fi|eld form|
|00004080| 2b 00 19 00 17 50 31 46 | 31 20 2d 20 52 4f 55 4e |+....P1F|1 - ROUN|
|00004090| 44 5b 50 31 46 31 2d 2e | 35 3b 31 5d 00 69 6d 61 |D[P1F1-.|5;1].ima|
|000040a0| 2c 00 9d 00 21 50 31 46 | 31 20 3d 20 47 20 66 6f |,...!P1F|1 = G fo|
|000040b0| 72 6d 61 74 74 65 64 20 | 6e 75 6d 65 72 69 63 20 |rmatted |numeric |
|000040c0| 66 69 65 6c 64 2e ff ff | 77 54 68 69 73 20 66 6f |field...|wThis fo|
|000040d0| 72 6d 75 6c 61 20 72 65 | 74 75 72 6e 73 20 74 68 |rmula re|turns th|
|000040e0| 65 20 64 65 63 69 6d 61 | 6c 20 70 6f 72 74 69 6f |e decima|l portio|
|000040f0| 6e 20 6f 66 20 74 68 65 | 20 6e 75 6d 62 65 72 2e |n of the| number.|
|00004100| 20 20 49 66 20 50 31 46 | 31 20 63 6f 6e 74 61 69 | If P1F|1 contai|
|00004110| 6e 73 20 74 68 65 20 6e | 75 6d 62 65 72 20 37 2e |ns the n|umber 7.|
|00004120| 35 34 37 36 2c 20 74 68 | 65 20 66 6f 72 6d 75 6c |5476, th|e formul|
|00004130| 61 20 72 65 74 75 72 6e | 73 20 2e 35 34 37 36 2e |a return|s .5476.|
|00004140| 00 4e 67 39 39 39 2e 39 | 22 3b 46 49 45 4c 44 5d |.Ng999.9|";FIELD]|
|00004150| 20 45 4e 44 49 46 22 2e | 20 20 54 68 65 20 66 6f | ENDIF".| The fo|
|00004160| 28 00 77 00 3d 63 61 74 | 2e 74 5b 50 23 46 23 3b |(.w.=cat|.t[P#F#;|
|00004170| 69 66 20 28 6c 65 6e 67 | 74 68 5b 50 23 46 23 5d |if (leng|th[P#F#]|
|00004180| 20 2f 2f 20 32 29 20 3d | 20 31 20 74 68 65 6e 20 | // 2) =| 1 then |
|00004190| 22 20 22 20 65 6c 73 65 | 20 22 2e 22 20 65 6e 64 |" " else| "." end|
|000041a0| 69 66 ff 36 20 20 20 22 | 20 2e 20 2e 20 2e 20 2e |if.6 "| . . . .|
|000041b0| 20 2e 20 2e 20 2e 20 2e | 20 2e 20 2e 20 2e 20 2e | . . . .| . . . .|
|000041c0| 20 2e 20 2e 20 2e 20 2e | 20 2e 20 2e 20 2e 20 2e | . . . .| . . . .|
|000041d0| 20 2e 20 2e 20 2e 20 2e | 22 5d 00 20 3d 20 22 20 | . . . .|"]. = " |
|000041e0| 04 00 f7 01 a8 50 23 46 | 23 20 3d 20 41 73 20 6c |.....P#F|# = As l|
|000041f0| 6f 6e 67 20 61 73 20 79 | 6f 75 20 77 61 6e 74 20 |ong as y|ou want |
|00004200| 61 73 20 6c 6f 6e 67 20 | 61 73 20 74 68 65 72 65 |as long |as there|
|00004210| 20 61 72 65 20 6d 6f 72 | 65 20 74 68 61 6e 20 65 | are mor|e than e|
|00004220| 6e 6f 75 67 68 20 64 6f | 74 73 20 63 6f 6e 63 61 |nough do|ts conca|
|00004230| 74 65 6e 61 74 65 64 20 | 6f 6e 74 6f 20 74 68 65 |tenated |onto the|
|00004240| 20 65 6e 64 20 74 68 61 | 74 20 79 6f 75 20 64 6f | end tha|t you do|
|00004250| 6e 27 74 20 72 75 6e 20 | 6f 75 74 20 77 68 65 6e |n't run |out when|
|00004260| 20 79 6f 75 20 70 72 69 | 6e 74 2f 64 69 73 70 6c | you pri|nt/displ|
|00004270| 61 79 20 74 68 65 20 63 | 6f 6e 74 65 6e 74 73 20 |ay the c|ontents |
|00004280| 6f 66 20 74 68 65 20 66 | 69 65 6c 64 2e ff ff fd |of the f|ield....|
|00004290| 54 68 69 73 20 66 6f 72 | 6d 75 6c 61 20 63 6f 6e |This for|mula con|
|000042a0| 63 61 74 65 6e 61 74 65 | 73 20 74 68 65 20 73 74 |catenate|s the st|
|000042b0| 72 69 6e 67 20 69 6e 20 | 50 23 46 23 20 77 69 74 |ring in |P#F# wit|
|000042c0| 68 20 61 20 64 6f 74 20 | 6c 65 61 64 65 72 2e 20 |h a dot |leader. |
|000042d0| 20 49 66 20 74 68 65 20 | 63 6f 6e 74 65 6e 74 73 | If the |contents|
|000042e0| 20 6f 66 20 50 23 46 23 | 20 68 61 73 20 61 6e 20 | of P#F#| has an |
|000042f0| 6f 64 64 20 6e 75 6d 62 | 65 72 20 6f 66 20 63 68 |odd numb|er of ch|
|00004300| 61 72 61 63 74 65 72 73 | 20 69 6e 20 69 74 20 74 |aracters| in it t|
|00004310| 68 65 6e 20 74 68 65 72 | 65 20 77 69 6c 6c 20 62 |hen ther|e will b|
|00004320| 65 20 74 77 6f 20 73 70 | 61 63 65 73 20 62 65 74 |e two sp|aces bet|
|00004330| 77 65 65 6e 20 74 68 65 | 20 73 74 72 69 6e 67 20 |ween the| string |
|00004340| 61 6e 64 20 74 68 65 20 | 64 6f 74 73 2c 20 6f 74 |and the |dots, ot|
|00004350| 68 65 72 77 69 73 65 20 | 74 68 65 72 65 20 77 69 |herwise |there wi|
|00004360| 6c 6c 20 6f 6e 6c 79 20 | 62 65 20 6f 6e 65 20 73 |ll only |be one s|
|00004370| 70 61 63 65 2e 20 20 28 | 4e 6f 74 65 3a 20 54 68 |pace. (|Note: Th|
|00004380| 69 73 20 69 73 20 61 63 | 63 6f 6d 70 6c 4c 69 73 |is is ac|complLis|
|00004390| 68 65 64 20 62 79 20 6e | 6f 74 20 70 75 74 74 69 |hed by n|ot putti|
|000043a0| 6e 67 20 61 20 73 65 6d | 69 63 6f 6c 6f 6e 20 28 |ng a sem|icolon (|
|000043b0| 3b 29 20 61 66 74 65 72 | 20 74 68 65 20 22 65 6e |;) after| the "en|
|000043c0| 64 69 66 22 20 65 6e 64 | 20 62 65 66 6f 72 65 20 |dif" end| before |
|000043d0| 74 68 65 20 64 6f 74 73 | 2e 29 00 74 68 65 20 66 |the dots|.).the f|
|000043e0| 10 00 8b 00 89 54 69 6d | 65 20 66 69 65 6c 64 73 |.....Tim|e fields|
|000043f0| 20 61 72 65 20 73 74 6f | 72 65 64 20 69 6e 20 73 | are sto|red in s|
|00004400| 65 63 6f 6e 64 73 2e 20 | 20 54 6f 20 63 6f 6e 76 |econds. | To conv|
|00004410| 65 72 74 20 74 68 65 20 | 76 61 6c 75 65 20 6f 66 |ert the |value of|
|00004420| 20 61 20 74 69 6d 65 20 | 74 6f 20 68 6f 75 72 73 | a time |to hours|
|00004430| 2c 20 64 69 76 69 64 65 | 20 74 68 65 20 76 61 6c |, divide| the val|
|00004440| 75 65 20 62 79 20 33 36 | 30 30 20 28 74 68 65 20 |ue by 36|00 (the |
|00004450| 6e 75 6d 62 65 72 20 6f | 66 20 73 65 63 6f 6e 64 |number o|f second|
|00004460| 73 20 69 6e 20 61 6e 20 | 68 6f 75 72 29 2e 00 20 |s in an |hour).. |
|00004470| 20 54 68 65 20 66 6f 72 | 6d 75 6c 61 20 77 69 6c | The for|mula wil|
|00004480| 05 00 eb 00 12 50 31 46 | 31 20 3d 20 44 61 74 65 |.....P1F|1 = Date|
|00004490| 20 66 69 65 6c 64 2e ff | ff d4 49 66 20 74 68 65 | field..|..If the|
|000044a0| 20 79 65 61 72 20 69 73 | 20 64 69 76 69 73 69 62 | year is| divisib|
|000044b0| 6c 65 20 62 79 20 34 30 | 30 20 28 77 69 74 68 70 |le by 40|0 (withp|
|000044c0| 75 74 20 61 20 72 65 6d | 61 69 6e 64 65 72 29 20 |ut a rem|ainder) |
|000044d0| 74 68 65 6e 20 74 68 65 | 20 66 6f 72 6d 75 6c 61 |then the| formula|
|000044e0| 20 77 69 6c 6c 20 72 65 | 74 75 72 6e 20 74 68 65 | will re|turn the|
|000044f0| 20 77 6f 72 64 20 22 4c | 65 61 70 22 20 6d 65 61 | word "L|eap" mea|
|00004500| 6e 69 6e 67 20 74 68 61 | 74 20 69 74 20 69 73 20 |ning tha|t it is |
|00004510| 61 20 6c 65 61 70 20 79 | 65 61 72 3b 20 6f 74 68 |a leap y|ear; oth|
|00004520| 65 72 77 69 73 65 2c 20 | 74 68 65 20 66 6f 72 6d |erwise, |the form|
|00004530| 75 6c 61 20 77 69 6c 6c | 20 72 65 74 75 72 6e 20 |ula will| return |
|00004540| 22 6e 6f 74 20 4c 65 61 | 70 22 20 6d 65 61 6e 69 |"not Lea|p" meani|
|00004550| 6e 67 20 74 68 61 74 20 | 69 74 20 69 73 20 6e 6f |ng that |it is no|
|00004560| 74 20 61 20 6c 65 61 70 | 20 79 65 61 72 2e 00 59 |t a leap| year..Y|
|00004570| 2f 4e 2e 22 20 20 59 6f | 75 20 77 69 6c 6c 20 74 |/N." Yo|u will t|
|00004580| 08 00 1d 00 1b 61 70 70 | 6c 79 2e 66 6f 72 6d 61 |.....app|ly.forma|
|00004590| 74 5b 22 41 34 30 3b 3b | 42 22 3b 50 23 46 23 5d |t["A40;;|B";P#F#]|
|000045a0| 00 22 46 22 20 74 68 65 | 6e 20 50 23 46 23 20 65 |."F" the|n P#F# e|
|000045b0| 6c 73 65 20 22 20 22 20 | 65 6e 64 69 66 00 73 20 |lse " " |endif.s |
|000045c0| 02 00 5c 03 9e 49 6e 20 | 61 20 66 6f 72 6d 75 6c |..\..In |a formul|
|000045d0| 61 2c 20 61 6c 6c 20 63 | 68 61 72 61 63 74 65 72 |a, all c|haracter|
|000045e0| 20 73 74 72 69 6e 67 73 | 20 74 68 61 74 20 61 72 | strings| that ar|
|000045f0| 65 20 6e 6f 74 20 72 65 | 73 65 72 76 65 64 20 77 |e not re|served w|
|00004600| 6f 72 64 73 20 28 77 6f | 72 64 73 20 75 73 65 64 |ords (wo|rds used|
|00004610| 20 61 73 20 6f 70 65 72 | 61 74 6f 72 73 2c 20 75 | as oper|ators, u|
|00004620| 73 65 64 20 69 6e 20 73 | 74 61 74 65 6d 65 6e 74 |sed in s|tatement|
|00004630| 73 2c 20 6f 72 20 75 73 | 65 64 20 69 6e 20 66 6f |s, or us|ed in fo|
|00004640| 72 6d 75 6c 61 73 29 20 | 6d 75 73 74 20 62 65 20 |rmulas) |must be |
|00004650| 65 6e 63 6c 6f 73 65 64 | 20 69 6e 20 71 75 6f 74 |enclosed| in quot|
|00004660| 65 73 2e ff 10 50 72 6f | 62 61 62 6c 65 20 43 61 |es...Pro|bable Ca|
|00004670| 75 73 65 73 3a ff a5 28 | 31 29 20 4d 69 73 70 65 |uses:..(|1) Mispe|
|00004680| 6c 6c 65 64 20 44 61 74 | 61 50 65 72 66 65 63 74 |lled Dat|aPerfect|
|00004690| 20 72 65 73 65 72 76 65 | 64 20 77 6f 72 64 73 2e | reserve|d words.|
|000046a0| 20 20 28 45 67 2e 20 45 | 4e 44 20 49 46 20 69 6e | (Eg. E|ND IF in|
|000046b0| 73 74 65 61 64 20 6f 66 | 20 45 4e 44 49 46 2c 20 |stead of| ENDIF, |
|000046c0| 45 4c 53 45 49 46 20 69 | 6e 73 74 65 61 64 20 6f |ELSEIF i|nstead o|
|000046d0| 66 20 45 4c 53 45 20 49 | 46 2c 20 54 48 41 4e 20 |f ELSE I|F, THAN |
|000046e0| 69 6e 73 74 65 61 64 20 | 6f 66 20 54 48 45 4e 2c |instead |of THEN,|
|000046f0| 20 41 50 50 4c 59 20 46 | 4f 52 4d 41 54 20 69 6e | APPLY F|ORMAT in|
|00004700| 73 74 65 61 64 20 6f 66 | 20 41 50 50 4c 59 2e 46 |stead of| APPLY.F|
|00004710| 4f 52 4d 41 54 2c 20 65 | 74 63 2e 29 ff fd 28 32 |ORMAT, e|tc.)..(2|
|00004720| 29 20 43 6f 70 79 69 6e | 67 20 61 20 66 6f 72 6d |) Copyin|g a form|
|00004730| 75 6c 61 20 66 72 6f 6d | 20 61 6e 6f 74 68 65 72 |ula from| another|
|00004740| 20 66 69 65 6c 64 20 6f | 72 20 66 72 6f 6d 20 61 | field o|r from a|
|00004750| 20 44 4f 53 20 66 69 6c | 65 20 69 6e 74 6f 20 74 | DOS fil|e into t|
|00004760| 68 65 20 53 68 65 6c 6c | 20 43 6c 69 70 62 6f 61 |he Shell| Clipboa|
|00004770| 72 64 20 69 6e 74 6f 20 | 79 6f 75 72 20 66 6f 72 |rd into |your for|
|00004780| 6d 75 6c 61 20 63 61 6e | 20 63 72 65 61 74 65 20 |mula can| create |
|00004790| 61 20 22 57 6f 72 64 20 | 4e 6f 74 20 52 65 63 6f |a "Word |Not Reco|
|000047a0| 67 6e 69 7a 65 64 22 20 | 65 72 72 6f 72 20 69 66 |gnized" |error if|
|000047b0| 20 79 6f 75 20 64 6f 20 | 6e 6f 74 20 63 68 61 6e | you do |not chan|
|000047c0| 67 65 20 61 6c 6c 20 50 | 23 46 23 20 74 65 78 74 |ge all P|#F# text|
|000047d0| 20 74 6f 20 72 65 61 6c | 20 63 6f 64 65 73 2e 20 | to real| codes. |
|000047e0| 20 46 69 65 6c 64 20 69 | 64 65 6e 74 69 66 69 65 | Field i|dentifie|
|000047f0| 72 73 20 28 73 75 63 68 | 20 61 73 20 50 31 46 31 |rs (such| as P1F1|
|00004800| 29 20 61 72 65 20 63 6f | 70 69 65 64 20 69 6e 74 |) are co|pied int|
|00004810| 6f 20 74 68 65 20 63 6c | 69 70 62 9d 6f 61 72 64 |o the cl|ipb.oard|
|00004820| 20 61 73 20 74 65 78 74 | 20 61 6e 64 20 6e 6f 74 | as text| and not|
|00004830| 20 61 73 20 74 68 65 20 | 6f 72 69 67 69 6e 61 6c | as the |original|
|00004840| 20 66 69 65 6c 64 20 69 | 64 65 6e 74 69 66 69 65 | field i|dentifie|
|00004850| 72 20 63 6f 64 65 73 2e | 20 20 54 6f 20 65 6c 69 |r codes.| To eli|
|00004860| 6d 69 6e 61 74 65 20 74 | 68 65 20 70 72 6f 62 6c |minate t|he probl|
|00004870| 65 6d 2c 20 64 65 6c 65 | 74 65 20 74 68 65 20 66 |em, dele|te the f|
|00004880| 61 6b 65 20 69 64 65 6e | 74 69 66 69 65 72 73 20 |ake iden|tifiers |
|00004890| 61 6e 64 20 72 65 2d 73 | 65 6c 65 63 74 20 74 68 |and re-s|elect th|
|000048a0| 65 20 66 69 65 6c 64 73 | 20 77 69 74 68 20 74 68 |e fields| with th|
|000048b0| 65 20 46 34 20 6b 65 79 | 2e ff ff 63 4e 6f 74 65 |e F4 key|...cNote|
|000048c0| 3a 20 44 61 74 61 50 65 | 72 66 65 63 74 20 77 69 |: DataPe|rfect wi|
|000048d0| 6c 6c 20 70 6c 61 63 65 | 20 74 68 65 20 63 75 72 |ll place| the cur|
|000048e0| 73 6f 72 20 61 74 20 74 | 68 65 20 70 6f 69 6e 74 |sor at t|he point|
|000048f0| 20 69 6e 20 74 68 65 20 | 66 6f 72 6d 75 6c 61 20 | in the |formula |
|00004900| 77 68 65 72 65 20 69 74 | 20 74 68 69 6e 6b 73 20 |where it| thinks |
|00004910| 74 68 65 20 70 72 6f 62 | 6c 65 6d 20 69 73 2e 00 |the prob|lem is..|
|00004920| 1b 00 7b 00 1c 50 31 46 | 31 20 3d 20 4e 39 39 39 |..{..P1F|1 = N999|
|00004930| 20 66 6f 72 6d 61 74 74 | 65 64 20 66 69 65 6c 64 | formatt|ed field|
|00004940| 2e ff ff 3f 54 68 69 73 | 20 66 6f 72 6d 75 6c 61 |...?This| formula|
|00004950| 20 72 65 76 65 72 73 65 | 73 20 74 68 65 20 6f 72 | reverse|s the or|
|00004960| 64 65 72 20 6f 66 20 64 | 61 74 61 20 77 69 74 68 |der of d|ata with|
|00004970| 69 6e 20 61 20 6e 75 6d | 65 72 69 63 20 66 69 65 |in a num|eric fie|
|00004980| 6c 64 2e ff 19 45 78 61 | 6d 70 6c 65 3a 20 20 32 |ld...Exa|mple: 2|
|00004990| 30 31 20 62 65 63 6f 6d | 65 73 20 31 30 32 00 70 |01 becom|es 102.p|
|000049a0| 04 00 15 00 13 72 6f 75 | 6e 64 5b 50 23 46 23 2b |.....rou|nd[P#F#+|
|000049b0| 2e 30 32 3b 2e 30 35 5d | 00 3b 31 5d 5d 5d 00 4f |.02;.05]|.;1]]].O|
|000049c0| 01 00 9b 00 0f 63 6f 6e | 76 65 72 74 5b 22 4e 39 |.....con|vert["N9|
|000049d0| 39 39 22 3b ff 06 63 61 | 74 2e 74 5b ff 29 73 75 |99";..ca|t.t[.)su|
|000049e0| 62 73 74 72 69 6e 67 5b | 61 70 70 6c 79 2e 66 6f |bstring[|apply.fo|
|000049f0| 72 6d 61 74 5b 22 4e 39 | 39 39 22 3b 50 23 46 23 |rmat["N9|99";P#F#|
|00004a00| 5d 3b 33 3b 31 5d 3b ff | 29 73 75 62 73 74 72 69 |];3;1];.|)substri|
|00004a10| 6e 67 5b 61 70 70 6c 79 | 2e 66 6f 72 6d 61 74 5b |ng[apply|.format[|
|00004a20| 22 4e 39 39 39 22 3b 50 | 23 46 23 5d 3b 32 3b 31 |"N999";P|#F#];2;1|
|00004a30| 5d 3b ff 2a 73 75 62 73 | 74 72 69 6e 67 5b 61 70 |];.*subs|tring[ap|
|00004a40| 70 6c 79 2e 66 6f 72 6d | 61 74 5b 22 4e 39 39 39 |ply.form|at["N999|
|00004a50| 22 3b 50 23 46 23 5d 3b | 31 3b 31 5d 5d 5d 00 70 |";P#F#];|1;1]]].p|
|00004a60| 05 00 42 00 40 63 6f 6e | 76 65 72 74 5b 22 4e 39 |..B.@con|vert["N9|
|00004a70| 39 22 3b 73 75 62 73 74 | 72 69 6e 67 5b 61 70 70 |9";subst|ring[app|
|00004a80| 6c 79 2e 66 6f 72 6d 61 | 74 5b 22 44 59 4d 44 39 |ly.forma|t["DYMD9|
|00004a90| 39 2f 39 39 2f 39 39 22 | 3b 74 6f 64 61 79 5d 3b |9/99/99"|;today];|
|00004aa0| 31 3b 32 5d 5d 00 74 20 | 6e 69 63 6b 65 6c 2e ff |1;2]].t |nickel..|
|00004ab0| 47 45 78 61 6d 70 6c 65 | 3a 20 38 30 2e 32 31 20 |GExample|: 80.21 |
|00004ac0| 03 00 61 00 21 69 66 20 | 73 75 62 73 74 72 69 6e |..a.!if |substrin|
|00004ad0| 67 5b 50 23 46 23 3b 31 | 3b 31 5d 20 3e 3d 20 22 |g[P#F#;1|;1] >= "|
|00004ae0| 41 22 20 61 6e 64 ff 3c | 20 20 20 73 75 62 73 74 |A" and.<| subst|
|00004af0| 72 69 6e 67 5b 50 23 46 | 23 3b 31 3b 31 5d 20 3c |ring[P#F|#;1;1] <|
|00004b00| 3d 20 22 5a 22 20 74 68 | 65 6e 20 22 43 61 6e 61 |= "Z" th|en "Cana|
|00004b10| 64 61 22 20 65 6c 73 65 | 20 22 55 53 41 22 20 65 |da" else| "USA" e|
|00004b20| 6e 64 69 66 00 20 6f 66 | 20 74 68 65 20 74 77 6f |ndif. of| the two|
|00004b30| 20 63 68 6f 69 63 65 73 | 20 6d 61 64 61 74 6f 72 | choices| madator|
|00004b40| 04 00 1b 00 19 28 28 74 | 6f 64 61 79 20 2d 20 50 |.....((t|oday - P|
|00004b50| 23 46 23 29 20 2f 20 33 | 36 35 2e 32 35 29 00 68 |#F#) / 3|65.25).h|
|00004b60| 01 00 df 01 2b 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |....+---|--------|
|00004b70| 2d 2d 46 49 52 53 54 20 | 50 41 47 45 20 48 45 41 |--FIRST |PAGE HEA|
|00004b80| 44 45 52 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |DER-----|--------|
|00004b90| ff 2b 2d 2d 20 50 72 6f | 6d 70 74 20 66 6f 72 20 |.+-- Pro|mpt for |
|00004ba0| 56 61 6c 75 65 20 69 6e | 20 52 65 70 6f 72 74 20 |Value in| Report |
|00004bb0| 56 61 72 69 61 62 6c 65 | 20 31 20 2d 2d ff 2b 2d |Variable| 1 --.+-|
|00004bc0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 52 |--------|-------R|
|00004bd0| 45 50 4f 52 54 20 42 4f | 44 59 2d 2d 2d 2d 2d 2d |EPORT BO|DY------|
|00004be0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d ff 2b 2d 2d 20 53 |--------|--.+-- S|
|00004bf0| 74 6f 70 20 5b 53 75 62 | 5d 52 65 70 6f 72 74 20 |top [Sub|]Report |
|00004c00| 69 66 20 30 20 28 46 61 | 6c 73 65 29 20 69 6e 20 |if 0 (Fa|lse) in |
|00004c10| 52 56 31 20 2d 2d 2d ff | 2a b0 b0 b0 b0 b0 b0 b0 |RV1 ---.|*.......|
|00004c20| b0 b0 b0 b0 b0 b0 b0 b0 | 20 b0 b0 b0 b0 b0 b0 b0 |........| .......|
|00004c30| b0 b0 b0 b0 b0 b0 b0 b0 | 20 20 20 20 20 20 20 20 |........| |
|00004c40| 20 20 bf ff 2a b0 b0 b0 | b0 b0 b0 b0 b0 b0 b0 b0 | ..*...|........|
|00004c50| b0 b0 b0 b0 b0 b0 b0 b0 | b0 b0 b0 b0 b0 b0 b0 b0 |........|........|
|00004c60| b0 b0 b0 b0 b0 b0 b0 b0 | b0 b0 b0 b0 b0 20 b3 ff |........|..... ..|
|00004c70| 44 b0 b0 b0 b0 b0 b0 b0 | b0 b0 b0 b0 b0 b0 b0 b0 |D.......|........|
|00004c80| b0 b0 b0 b0 b0 b0 b0 b0 | b0 b0 b0 b0 b0 b0 b0 b0 |........|........|
|00004c90| b0 b0 b0 b0 b0 b0 b0 b0 | b0 20 c3 c4 20 46 69 65 |........|. .. Fie|
|00004ca0| 6c 64 73 20 53 65 6c 65 | 63 74 65 64 20 74 6f 20 |lds Sele|cted to |
|00004cb0| 50 72 69 6e 74 ff 2a b0 | b0 b0 b0 b0 b0 b0 b0 b0 |Print.*.|........|
|00004cc0| b0 b0 b0 b0 b0 b0 b0 b0 | b0 b0 b0 b0 b0 b0 b0 b0 |........|........|
|00004cd0| b0 b0 b0 b0 b0 b0 b0 b0 | b0 b0 b0 b0 b0 b0 b0 20 |........|....... |
|00004ce0| b3 ff 2a b0 b0 b0 b0 b0 | b0 b0 b0 b0 b0 b0 b0 b0 |..*.....|........|
|00004cf0| b0 b0 b0 b0 b0 b0 b0 b0 | b0 b0 b0 b0 2c 20 b0 b0 |........|...., ..|
|00004d00| 20 b0 b0 b0 b0 b0 b0 b0 | b0 b0 b0 20 d9 ff 33 2d | .......|... ..3-|
|00004d10| 2d 2d 2d 20 53 74 6f 72 | 65 20 56 61 6c 75 65 20 |--- Stor|e Value |
|00004d20| 69 6e 20 52 65 70 6f 72 | 74 20 56 61 72 69 61 62 |in Repor|t Variab|
|00004d30| 65 6c 20 31 20 2d 2d 20 | 5d 20 20 28 72 76 31 2d |el 1 -- |] (rv1-|
|00004d40| 31 29 00 00 25 49 46 20 | 50 31 46 34 20 3e 3d 20 |1)..%IF |P1F4 >= |
|00004d50| 2e 30 20 41 4e 44 20 50 | 31 46 34 20 3c 3d 20 2e |.0 AND P|1F4 <= .|
|00004d60| 10 00 00 00 1a 00 e3 01 | 00 60 03 00 20 61 20 64 |........|.`.. a d|
|00004d70| 65 73 63 72 69 70 74 69 | 6f 6e 20 6f 66 20 68 6f |escripti|on of ho|
|00004d80| 77 20 74 6f 20 70 72 69 | 6e 74 20 6f 6e 6c 79 20 |w to pri|nt only |
|00004d90| 74 68 65 20 66 69 72 73 | 74 20 3c 23 23 3e 20 72 |the firs|t <##> r|
|00004da0| 65 63 6f 72 64 73 20 69 | 6e 20 61 20 70 61 6e 65 |ecords i|n a pane|
|00004db0| 6c 20 28 6e 75 6d 62 65 | 72 20 64 65 70 65 6e 64 |l (numbe|r depend|
|00004dc0| 69 6e 67 20 75 70 6f 6e | 20 61 6d 6f 75 6e 74 20 |ing upon| amount |
|00004dd0| 65 6e 74 65 72 65 64 20 | 62 79 20 75 73 65 72 29 |entered |by user)|
|00004de0| 2e 20 20 54 68 65 20 66 | 6f 6c 6c 6f 77 69 6e 67 |. The f|ollowing|
|00004df0| 20 73 74 65 70 73 20 73 | 68 6f 77 20 68 6f 77 20 | steps s|how how |
|00004e00| 74 6f 20 61 63 63 6f 6d | 70 6c 69 73 68 20 74 68 |to accom|plish th|
|00004e10| 69 73 20 28 74 68 65 73 | 65 20 73 74 65 70 73 20 |is (thes|e steps |
|00004e20| 61 73 73 75 6d 65 20 74 | 68 61 74 20 52 56 31 20 |assume t|hat RV1 |
|00004e30| 69 73 20 61 76 61 69 6c | 61 62 6c 65 29 3a ff a7 |is avail|able):..|
|00004e40| 28 31 29 20 43 72 65 61 | 74 65 20 61 20 70 72 6f |(1) Crea|te a pro|
|00004e50| 6d 70 74 20 66 6f 72 20 | 72 76 31 20 69 6e 20 74 |mpt for |rv1 in t|
|00004e60| 68 65 20 46 69 72 73 74 | 20 50 61 67 65 20 48 65 |he First| Page He|
|00004e70| 61 64 65 72 20 28 45 67 | 2e 20 22 45 6e 74 65 72 |ader (Eg|. "Enter|
|00004e80| 20 4e 75 6d 62 65 72 20 | 6f 66 20 52 65 63 6f 72 | Number |of Recor|
|00004e90| 64 73 20 74 6f 20 45 78 | 70 6f 72 74 3a 20 22 20 |ds to Ex|port: " |
|00004ea0| 2d 2d 20 66 6f 72 6d 61 | 74 20 47 5a 5a 39 29 2e |-- forma|t GZZ9).|
|00004eb0| 20 20 54 68 69 73 20 69 | 73 20 74 68 65 20 6e 75 | This i|s the nu|
|00004ec0| 6d 62 65 72 20 6f 66 20 | 72 65 63 6f 72 64 73 20 |mber of |records |
|00004ed0| 74 6f 20 62 65 20 65 78 | 70 6f 72 74 65 64 2f 70 |to be ex|ported/p|
|00004ee0| 72 69 6e 74 65 64 2e ff | 84 28 32 29 20 41 74 20 |rinted..|.(2) At |
|00004ef0| 74 68 65 20 62 65 67 69 | 6e 6e 69 6e 67 20 6f 66 |the begi|nning of|
|00004f00| 20 74 68 65 20 72 65 70 | 6f 72 74 20 62 6f 64 79 | the rep|ort body|
|00004f10| 20 61 64 64 20 61 20 22 | 53 74 6f 70 20 5b 53 75 | add a "|Stop [Su|
|00004f20| 62 5d 52 65 70 6f 72 74 | 22 20 63 6f 6d 6d 61 6e |b]Report|" comman|
|00004f30| 64 20 66 6f 72 20 72 76 | 31 2e 20 20 57 68 65 6e |d for rv|1. When|
|00004f40| 20 74 68 65 20 76 61 6c | 75 65 20 67 65 74 73 20 | the val|ue gets |
|00004f50| 74 6f 20 7a 65 72 6f 20 | 74 68 65 20 72 65 70 6f |to zero |the repo|
|00004f60| 72 74 20 77 69 6c 6c 20 | 73 74 6f 70 2e ff 9e 28 |rt will |stop...(|
|00004f70| 33 29 20 53 65 6c 65 63 | 74 20 74 68 65 20 66 69 |3) Selec|t the fi|
|00004f80| 65 6c 64 73 20 74 68 61 | 74 20 61 72 65 20 74 6f |elds tha|t are to|
|00004f90| 20 62 65 20 75 73 65 64 | 20 66 6f 72 20 74 68 65 | be used| for the|
|00004fa0| 20 72 65 70 6f 72 74 2e | 20 20 41 74 20 74 68 65 | report.| At the|
|00004fb0| 20 65 6e 64 20 6f 66 20 | 74 68 65 20 72 65 70 6f | end of |the repo|
|00004fc0| 72 74 20 62 6f 64 79 2c | 20 65 6e 74 65 72 20 61 |rt body,| enter a|
|00004fd0| 6e 6f 74 68 65 72 20 fe | 53 74 6f 72 65 20 56 61 |nother .|Store Va|
|00004fe0| 6c 75 65 20 69 6e 20 52 | 56 31 fe 2e 20 20 54 68 |lue in R|V1.. Th|
|00004ff0| 69 73 20 74 69 6d 65 2c | 20 74 68 65 20 66 6f 72 |is time,| the for|
|00005000| 6d 75 6c 61 20 66 6f 72 | 20 74 68 65 20 83 72 65 |mula for| the .re|
|00005010| 70 6f 72 74 20 76 61 72 | 69 61 62 6c 65 20 69 73 |port var|iable is|
|00005020| 20 fe 49 46 20 52 56 31 | 3d 30 20 54 48 45 4e 20 | .IF RV1|=0 THEN |
|00005030| 30 20 45 4c 53 45 20 52 | 56 31 2d 31 20 45 4e 44 |0 ELSE R|V1-1 END|
|00005040| 49 46 fe 2e 20 20 54 68 | 69 73 20 77 69 6c 6c 20 |IF.. Th|is will |
|00005050| 64 65 63 72 65 6d 65 6e | 74 20 28 61 6e 6e 6f 75 |decremen|t (annou|
|00005060| 6e 63 65 29 20 74 68 65 | 20 52 56 20 66 6f 72 20 |nce) the| RV for |
|00005070| 74 68 65 20 72 65 63 6f | 72 64 20 74 68 61 74 20 |the reco|rd that |
|00005080| 77 61 73 20 6a 75 73 74 | 20 70 72 69 6e 74 65 64 |was just| printed|
|00005090| 2e 00 54 52 49 4e 47 5b | 50 31 46 31 3b 31 3b 36 |..TRING[|P1F1;1;6|
|000050a0| 1a 00 23 03 d9 54 68 69 | 73 20 69 73 20 61 20 64 |..#..Thi|s is a d|
|000050b0| 65 73 63 72 69 70 74 69 | 6f 6e 20 6f 66 20 68 6f |escripti|on of ho|
|000050c0| 77 20 74 6f 20 70 72 69 | 6e 74 20 6f 6e 6c 79 20 |w to pri|nt only |
|000050d0| 74 68 65 20 66 69 72 73 | 74 20 3c 23 23 3e 20 72 |the firs|t <##> r|
|000050e0| 65 63 6f 72 64 73 20 69 | 6e 20 61 20 70 61 6e 65 |ecords i|n a pane|
|000050f0| 6c 20 28 6e 75 6d 62 65 | 72 20 64 65 70 65 6e 64 |l (numbe|r depend|
|00005100| 69 6e 67 20 75 70 6f 6e | 20 61 6d 6f 75 6e 74 20 |ing upon| amount |
|00005110| 65 6e 74 65 72 65 64 20 | 62 79 20 75 73 65 72 29 |entered |by user)|
|00005120| 2e 20 20 54 68 65 20 66 | 6f 6c 6c 6f 77 69 6e 67 |. The f|ollowing|
|00005130| 20 73 74 65 70 73 20 73 | 68 6f 77 20 68 6f 77 20 | steps s|how how |
|00005140| 74 6f 20 61 63 63 6f 6d | 70 6c 69 73 68 20 74 68 |to accom|plish th|
|00005150| 69 73 20 28 74 68 65 73 | 65 20 73 74 65 70 73 20 |is (thes|e steps |
|00005160| 61 73 73 75 6d 65 20 74 | 68 61 74 20 52 56 31 20 |assume t|hat RV1 |
|00005170| 69 73 20 61 76 61 69 6c | 61 62 6c 65 29 3a ff a7 |is avail|able):..|
|00005180| 28 31 29 20 43 72 65 61 | 74 65 20 61 20 70 72 6f |(1) Crea|te a pro|
|00005190| 6d 70 74 20 66 6f 72 20 | 72 76 31 20 69 6e 20 74 |mpt for |rv1 in t|
|000051a0| 68 65 20 46 69 72 73 74 | 20 50 61 67 65 20 48 65 |he First| Page He|
|000051b0| 61 64 65 72 20 28 45 67 | 2e 20 22 45 6e 74 65 72 |ader (Eg|. "Enter|
|000051c0| 20 4e 75 6d 62 65 72 20 | 6f 66 20 52 65 63 6f 72 | Number |of Recor|
|000051d0| 64 73 20 74 6f 20 45 78 | 70 6f 72 74 3a 20 22 20 |ds to Ex|port: " |
|000051e0| 2d 2d 20 66 6f 72 6d 61 | 74 20 47 5a 5a 39 29 2e |-- forma|t GZZ9).|
|000051f0| 20 20 54 68 69 73 20 69 | 73 20 74 68 65 20 6e 75 | This i|s the nu|
|00005200| 6d 62 65 72 20 6f 66 20 | 72 65 63 6f 72 64 73 20 |mber of |records |
|00005210| 74 6f 20 62 65 20 65 78 | 70 6f 72 74 65 64 2f 70 |to be ex|ported/p|
|00005220| 72 69 6e 74 65 64 2e ff | 84 28 32 29 20 41 74 20 |rinted..|.(2) At |
|00005230| 74 68 65 20 62 65 67 69 | 6e 6e 69 6e 67 20 6f 66 |the begi|nning of|
|00005240| 20 74 68 65 20 72 65 70 | 6f 72 74 20 62 6f 64 79 | the rep|ort body|
|00005250| 20 61 64 64 20 61 20 22 | 53 74 6f 70 20 5b 53 75 | add a "|Stop [Su|
|00005260| 62 5d 52 65 70 6f 72 74 | 22 20 63 6f 6d 6d 61 6e |b]Report|" comman|
|00005270| 64 20 66 6f 72 20 72 76 | 31 2e 20 20 57 68 65 6e |d for rv|1. When|
|00005280| 20 74 68 65 20 76 61 6c | 75 65 20 67 65 74 73 20 | the val|ue gets |
|00005290| 74 6f 20 7a 65 72 6f 20 | 74 68 65 20 72 65 70 6f |to zero |the repo|
|000052a0| 72 74 20 77 69 6c 6c 20 | 73 74 6f 70 2e ff 39 28 |rt will |stop..9(|
|000052b0| 33 29 20 53 65 6c 65 63 | 74 20 74 68 65 20 66 69 |3) Selec|t the fi|
|000052c0| 65 6c 64 73 20 74 68 61 | 74 20 61 72 65 20 74 6f |elds tha|t are to|
|000052d0| 20 62 65 20 75 73 65 64 | 20 66 6f 72 20 74 68 65 | be used| for the|
|000052e0| 20 72 65 70 6f 72 74 2e | ff dc 28 34 29 20 41 74 | report.|..(4) At|
|000052f0| 20 74 68 65 20 65 6e 64 | 20 6f 66 20 74 68 65 20 | the end| of the |
|00005300| 72 65 70 6f 72 74 20 62 | 6f 64 79 20 63 72 65 61 |report b|ody crea|
|00005310| 74 65 20 61 20 22 53 74 | 6f 72 65 20 56 61 6c 75 |te a "St|ore Valu|
|00005320| 65 20 69 6e 20 52 56 31 | 22 20 61 6e 64 20 65 6e |e in RV1|" and en|
|00005330| 74 65 72 20 74 68 65 20 | 66 6f 72 6d 75 6c 61 20 |ter the |formula |
|00005340| 22 72 76 31 2d 31 22 2e | 20 20 54 68 69 73 20 77 |"rv1-1".| This w|
|00005350| 69 6c 6c 20 64 65 63 72 | 65 6d 65 6e 74 20 74 68 |ill decr|ement th|
|00005360| 65 20 76 61 6c 75 65 20 | 70 72 6f 6d 70 74 65 64 |e value |prompted|
|00005370| 20 66 6f 72 20 75 6e 74 | 69 6c 20 69 74 20 72 65 | for unt|il it re|
|00005380| 61 63 68 65 73 20 30 2c | 20 74 68 75 73 20 74 72 |aches 0,| thus tr|
|00005390| 69 67 67 65 72 69 6e 67 | 20 74 68 65 20 22 53 74 |iggering| the "St|
|000053a0| 6f 70 20 5b 53 75 62 5d | 52 65 70 6f 72 74 22 20 |op [Sub]|Report" |
|000053b0| 61 6e 64 20 65 6e 64 69 | 6e 67 20 74 68 65 20 72 |and endi|ng the r|
|000053c0| 65 70 6f 72 74 2e 00 68 | 65 20 72 65 6d 61 69 6e |eport..h|e remain|
|000053d0| 69 6e 67 20 72 65 63 6f | 72 64 73 2e ff ff fd 33 |ing reco|rds....3|
|000053e0| 1a 00 26 01 0a 50 23 46 | 23 20 63 61 73 65 73 ff |..&..P#F|# cases.|
|000053f0| 12 63 61 73 65 20 63 76 | 20 3c 20 20 33 36 30 30 |.case cv| < 3600|
|00005400| 20 6f 66 ff 37 20 20 63 | 61 74 2e 74 5b 61 70 70 | of.7 c|at.t[app|
|00005410| 6c 79 2e 66 6f 72 6d 61 | 74 5b 22 54 5a 39 3a 39 |ly.forma|t["TZ9:9|
|00005420| 39 22 3b 28 50 23 46 23 | 2b 34 33 32 30 30 29 5d |9";(P#F#|+43200)]|
|00005430| 3b 22 61 6d 22 5d 20 65 | 6e 64 6f 66 ff 12 63 61 |;"am"] e|ndof..ca|
|00005440| 73 65 20 63 76 20 3c 20 | 34 33 32 30 30 20 6f 66 |se cv < |43200 of|
|00005450| ff 2f 20 20 63 61 74 2e | 74 5b 61 70 70 6c 79 2e |./ cat.|t[apply.|
|00005460| 66 6f 72 6d 61 74 5b 22 | 54 5a 39 3a 39 39 22 3b |format["|TZ9:99";|
|00005470| 50 23 46 23 5d 3b 22 61 | 6d 22 5d 20 65 6e 64 6f |P#F#];"a|m"] endo|
|00005480| 66 ff 12 63 61 73 65 20 | 63 76 20 3c 20 34 36 38 |f..case |cv < 468|
|00005490| 30 30 20 6f 66 ff 2f 20 | 20 63 61 74 2e 74 5b 61 |00 of./ | cat.t[a|
|000054a0| 70 70 6c 79 2e 66 6f 72 | 6d 61 74 5b 22 54 5a 39 |pply.for|mat["TZ9|
|000054b0| 3a 39 39 22 3b 50 23 46 | 23 5d 3b 22 70 6d 22 5d |:99";P#F|#];"pm"]|
|000054c0| 20 65 6e 64 6f 66 ff 37 | 64 65 66 61 75 6c 74 20 | endof.7|default |
|000054d0| 63 61 74 2e 74 5b 61 70 | 70 6c 79 2e 66 6f 72 6d |cat.t[ap|ply.form|
|000054e0| 61 74 5b 22 54 5a 39 3a | 39 39 22 3b 28 50 23 46 |at["TZ9:|99";(P#F|
|000054f0| 23 2d 34 33 32 30 30 29 | 5d 3b 22 70 6d 22 5d ff |#-43200)|];"pm"].|
|00005500| 08 65 6e 64 63 61 73 65 | 73 00 31 39 3b 31 5d 20 |.endcase|s.19;1] |
|00005510| 3d 20 22 26 22 20 54 48 | 45 4e ff 3c 43 41 54 2e |= "&" TH|EN.<CAT.|
|00005520| 0a 00 e6 00 10 69 66 20 | 50 23 46 23 20 3d 20 22 |.....if |P#F# = "|
|00005530| 4d 22 20 6f 72 ff 26 20 | 20 20 50 23 46 23 20 3d |M" or.& | P#F# =|
|00005540| 20 22 46 22 20 74 68 65 | 6e 20 50 23 46 23 20 65 | "F" the|n P#F# e|
|00005550| 6c 73 65 20 22 20 22 20 | 65 6e 64 69 66 ff ff 31 |lse " " |endif..1|
|00005560| 4f 72 20 69 66 20 79 6f | 75 20 68 61 76 65 20 6d |Or if yo|u have m|
|00005570| 6f 72 65 20 74 68 61 6e | 20 74 77 6f 20 69 74 65 |ore than| two ite|
|00005580| 6d 73 20 6f 6e 20 74 68 | 65 20 6c 69 73 74 2e 2e |ms on th|e list..|
|00005590| 2e ff ff 0a 50 23 46 23 | 20 63 61 73 65 73 ff 1a |....P#F#| cases..|
|000055a0| 63 61 73 65 20 63 76 20 | 3d 20 22 59 22 20 6f 66 |case cv |= "Y" of|
|000055b0| 20 22 59 22 20 65 6e 64 | 6f 66 ff 1a 63 61 73 65 | "Y" end|of..case|
|000055c0| 20 63 76 20 3d 20 22 4e | 22 20 6f 66 20 22 4e 22 | cv = "N|" of "N"|
|000055d0| 20 65 6e 64 6f 66 ff 1a | 63 61 73 65 20 63 76 20 | endof..|case cv |
|000055e0| 3d 20 22 55 22 20 6f 66 | 20 22 55 22 20 65 6e 64 |= "U" of| "U" end|
|000055f0| 6f 66 ff 0b 64 65 66 61 | 75 6c 74 20 22 20 22 ff |of..defa|ult " ".|
|00005600| 08 65 6e 64 63 61 73 65 | 73 00 30 50 4d 2c 20 61 |.endcase|s.0PM, a|
|00005610| 6e 64 20 73 6f 20 66 6f | 72 74 68 2e 00 4d 22 5d |nd so fo|rth..M"]|
|00005620| 08 00 5a 01 1a 50 23 46 | 23 20 3d 20 54 69 6d 65 |..Z..P#F|# = Time|
|00005630| 20 46 69 65 6c 64 20 28 | 54 5a 39 3a 39 39 29 ff | Field (|TZ9:99).|
|00005640| ff 43 49 66 20 74 68 65 | 20 74 69 6d 65 20 66 69 |.CIf the| time fi|
|00005650| 65 6c 64 20 69 73 20 7a | 65 72 6f 20 69 74 20 69 |eld is z|ero it i|
|00005660| 73 20 31 32 3a 30 30 61 | 6d 2e 20 20 28 54 69 6d |s 12:00a|m. (Tim|
|00005670| 65 20 66 69 65 6c 64 73 | 20 73 74 6f 72 65 20 74 |e fields| store t|
|00005680| 68 65 69 72 20 f7 76 61 | 6c 75 65 73 20 61 73 20 |heir .va|lues as |
|00005690| 74 68 65 20 74 6f 74 61 | 6c 20 6e 75 6d 62 65 72 |the tota|l number|
|000056a0| 20 6f 66 20 73 65 63 6f | 6e 64 73 20 73 69 6e 63 | of seco|nds sinc|
|000056b0| 65 20 31 32 20 6d 69 64 | 6e 69 67 68 74 2e 29 20 |e 12 mid|night.) |
|000056c0| 20 49 66 20 74 68 65 20 | 74 69 6d 65 20 65 6e 74 | If the |time ent|
|000056d0| 65 72 65 64 20 69 73 20 | 6f 76 65 72 20 31 32 3a |ered is |over 12:|
|000056e0| 30 30 20 68 6f 75 72 73 | 2c 20 69 74 20 77 69 6c |00 hours|, it wil|
|000056f0| 6c 20 73 75 62 74 72 61 | 63 74 20 31 32 20 68 6f |l subtra|ct 12 ho|
|00005700| 75 72 73 20 66 72 6f 6d | 20 74 68 65 20 74 69 6d |urs from| the tim|
|00005710| 65 20 61 6e 64 20 61 64 | 64 20 22 70 6d 22 20 74 |e and ad|d "pm" t|
|00005720| 6f 20 74 68 65 20 64 69 | 73 70 6c 61 79 65 64 20 |o the di|splayed |
|00005730| 74 69 6d 65 2e 20 20 28 | 45 67 2e 20 31 33 3a 30 |time. (|Eg. 13:0|
|00005740| 30 20 69 73 20 63 6f 6e | 76 65 72 74 65 64 20 74 |0 is con|verted t|
|00005750| 6f 20 31 3a 30 30 70 6d | 2c 20 31 34 3a 30 30 20 |o 1:00pm|, 14:00 |
|00005760| 69 73 20 63 6f 6e 76 65 | 72 74 65 64 20 74 6f 20 |is conve|rted to |
|00005770| 32 3a 30 30 70 6d 2c 20 | 65 74 63 2e 29 00 69 73 |2:00pm, |etc.).is|
|00005780| 0b 00 fa 01 2c 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |....,---|--------|
|00005790| 2d 2d 2d 46 49 52 53 54 | 20 50 41 47 45 20 48 45 |---FIRST| PAGE HE|
|000057a0| 41 44 45 52 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |ADER----|--------|
|000057b0| 2d ff 2c 2d 2d 20 50 72 | 6f 6d 70 74 20 66 6f 72 |-.,-- Pr|ompt for|
|000057c0| 20 56 61 6c 75 65 20 69 | 6e 20 52 65 70 6f 72 74 | Value i|n Report|
|000057d0| 20 56 61 72 69 61 62 6c | 65 20 31 20 2d 2d 2d ff | Variabl|e 1 ---.|
|000057e0| 2c 2d 2d 20 50 72 6f 6d | 70 74 20 66 6f 72 20 56 |,-- Prom|pt for V|
|000057f0| 61 6c 75 65 20 69 6e 20 | 52 65 70 6f 72 74 20 56 |alue in |Report V|
|00005800| 61 72 69 61 62 6c 65 20 | 32 20 2d 2d 2d ff 2c 2d |ariable |2 ---.,-|
|00005810| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00005820| 52 45 50 4f 52 54 20 42 | 4f 44 59 2d 2d 2d 2d 2d |REPORT B|ODY-----|
|00005830| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d ff 2c 2d 2d 2d |--------|---.,---|
|00005840| 2d 2d 20 53 74 6f 72 65 | 20 56 61 6c 75 65 20 69 |-- Store| Value i|
|00005850| 6e 20 52 65 70 6f 72 74 | 20 56 61 72 69 61 62 6c |n Report| Variabl|
|00005860| 65 20 33 20 2d 2d 2d 2d | 2d ff 2c 2d 2d 20 53 6b |e 3 ----|-.,-- Sk|
|00005870| 69 70 20 69 66 20 30 20 | 28 46 61 6c 73 65 29 20 |ip if 0 |(False) |
|00005880| 69 6e 20 52 65 70 6f 72 | 74 20 56 61 72 69 61 62 |in Repor|t Variab|
|00005890| 6c 65 20 33 20 2d 2d ff | 2c 3d 3d 3d 3d 3d 3d 3d |le 3 --.|,=======|
|000058a0| 3d 3d 20 53 55 42 52 45 | 50 4f 52 54 20 4c 49 4e |== SUBRE|PORT LIN|
|000058b0| 4b 2f 50 41 4e 45 4c 3a | 20 2e 2e 2e 20 3d 3d 3d |K/PANEL:| ... ===|
|000058c0| 3d 3d 3d 3d 3d ff 2c 2d | 2d 2d 2d 2d 2d 2d 2d 2d |=====.,-|--------|
|000058d0| 2d 2d 2d 2d 2d 2d 2d 2d | 52 45 50 4f 52 54 20 42 |--------|REPORT B|
|000058e0| 4f 44 59 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |ODY-----|--------|
|000058f0| 2d 2d 2d ff 2c 2d 2d 2d | 2d 20 53 74 6f 72 65 20 |---.,---|- Store |
|00005900| 52 65 70 6f 72 74 20 56 | 61 72 69 61 62 6c 65 20 |Report V|ariable |
|00005910| 32 20 69 6e 20 46 69 65 | 6c 64 20 23 20 2d 2d 2d |2 in Fie|ld # ---|
|00005920| 2d ff 2c 3d 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |-.,=====|========|
|00005930| 3d 20 45 4e 44 20 53 55 | 42 52 45 50 4f 52 54 20 |= END SU|BREPORT |
|00005940| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d ff |========|=======.|
|00005950| 2c 2d 2d 2d 2d 20 53 74 | 6f 72 65 20 52 65 70 6f |,---- St|ore Repo|
|00005960| 72 74 20 56 61 72 69 61 | 62 6c 65 20 32 20 69 6e |rt Varia|ble 2 in|
|00005970| 20 46 69 65 6c 64 20 23 | 20 2d 2d 2d 2d 00 6f 72 | Field #| ----.or|
|00005980| 10 00 08 00 06 2d 74 6f | 64 61 79 00 20 66 6f 72 |.....-to|day. for|
|00005990| 6d 61 74 20 74 6f 20 6d | 61 6b 65 20 65 6e 74 72 |mat to m|ake entr|
|000059a0| 01 00 19 00 17 63 6f 6e | 74 61 69 6e 73 5b 50 23 |.....con|tains[P#|
|000059b0| 46 23 3b 22 7c 25 24 25 | 2a 25 22 5d 00 61 64 61 |F#;"|%$%|*%"].ada|
|000059c0| 01 00 0c 00 0a 72 76 23 | 20 2b 20 50 23 46 23 00 |.....rv#| + P#F#.|
|000059d0| 73 69 64 65 72 20 74 68 | 65 20 64 65 63 69 6d 61 |sider th|e decima|
|000059e0| 01 00 5a 01 19 50 23 46 | 23 20 3d 20 50 6f 73 74 |..Z..P#F|# = Post|
|000059f0| 61 6c 20 63 6f 64 65 20 | 66 69 65 6c 64 2e ff 8c |al code |field...|
|00005a00| 54 68 69 73 20 66 6f 72 | 6d 75 6c 61 20 69 73 20 |This for|mula is |
|00005a10| 64 65 73 69 67 6e 65 64 | 20 74 6f 20 63 68 65 63 |designed| to chec|
|00005a20| 6b 20 74 68 65 20 64 61 | 74 61 20 65 6e 74 65 72 |k the da|ta enter|
|00005a30| 65 64 20 69 6e 20 61 20 | 43 61 6e 61 64 69 61 6e |ed in a |Canadian|
|00005a40| 20 70 6f 73 74 61 6c 20 | 63 6f 64 65 20 66 69 65 | postal |code fie|
|00005a50| 6c 64 2e 20 20 49 74 20 | 63 6f 6e 66 69 72 6d 73 |ld. It |confirms|
|00005a60| 20 74 68 61 74 20 74 68 | 65 20 63 6f 72 72 65 63 | that th|e correc|
|00005a70| 74 20 73 65 71 75 65 6e | 63 65 20 6f 66 20 63 68 |t sequen|ce of ch|
|00005a80| 61 72 61 63 74 65 72 73 | 20 69 73 20 b0 65 6e 74 |aracters| is .ent|
|00005a90| 65 72 65 64 20 69 6e 20 | 74 68 65 20 66 69 65 6c |ered in |the fiel|
|00005aa0| 64 2e 20 20 28 46 6f 72 | 20 65 78 61 6d 70 6c 65 |d. (For| example|
|00005ab0| 2c 20 41 23 41 20 23 41 | 23 20 77 68 65 72 65 20 |, A#A #A|# where |
|00005ac0| 41 20 3d 20 61 6e 20 61 | 6c 70 68 61 20 63 68 61 |A = an a|lpha cha|
|00005ad0| 72 61 63 74 65 72 20 61 | 6e 64 20 23 20 65 71 75 |racter a|nd # equ|
|00005ae0| 61 6c 73 20 61 20 6e 75 | 6d 65 72 69 63 20 76 61 |als a nu|meric va|
|00005af0| 6c 75 65 2e 20 20 4e 6f | 74 69 63 65 20 74 68 61 |lue. No|tice tha|
|00005b00| 74 20 74 68 65 72 65 20 | 69 73 20 61 20 73 70 61 |t there |is a spa|
|00005b10| 63 65 20 62 65 74 77 65 | 65 6e 20 74 68 65 20 74 |ce betwe|en the t|
|00005b20| 77 6f 20 73 65 74 73 20 | 6f 66 20 74 68 72 65 65 |wo sets |of three|
|00005b30| 20 63 68 61 72 61 63 74 | 65 72 73 2e 29 00 6e 20 | charact|ers.).n |
|00005b40| 0b 00 da 00 55 50 23 46 | 23 20 3d 20 41 6c 70 68 |....UP#F|# = Alph|
|00005b50| 61 6e 75 6d 65 72 69 63 | 20 66 69 65 6c 64 20 77 |anumeric| field w|
|00005b60| 68 65 72 65 69 6e 20 61 | 20 5a 49 50 2f 70 6f 73 |herein a| ZIP/pos|
|00005b70| 74 61 6c 20 63 6f 64 65 | 20 69 73 20 73 74 6f 72 |tal code| is stor|
|00005b80| 65 64 2e 20 20 28 41 20 | 55 31 30 20 77 6f 72 6b |ed. (A |U10 work|
|00005b90| 73 20 6e 69 63 65 6c 79 | 2e 29 ff ff 80 44 65 74 |s nicely|.)...Det|
|00005ba0| 65 72 6d 69 6e 65 73 20 | 69 66 20 74 68 65 20 66 |ermines |if the f|
|00005bb0| 69 72 73 74 20 63 68 61 | 72 61 63 74 65 72 20 6f |irst cha|racter o|
|00005bc0| 66 20 74 68 65 20 63 6f | 64 65 20 69 73 20 61 6e |f the co|de is an|
|00005bd0| 20 61 6c 70 68 61 20 63 | 68 61 72 61 63 74 65 72 | alpha c|haracter|
|00005be0| 2e 20 20 49 66 20 69 74 | 20 69 73 2c 20 74 68 65 |. If it| is, the|
|00005bf0| 6e 20 74 68 65 20 63 6f | 75 6e 74 72 79 20 69 73 |n the co|untry is|
|00005c00| 20 43 61 6e 61 64 61 3b | 20 6f 74 68 65 72 77 69 | Canada;| otherwi|
|00005c10| 73 65 20 69 74 20 69 73 | 20 55 53 41 2e 00 72 79 |se it is| USA..ry|
|00005c20| 07 00 00 00 0d 00 00 00 | 00 39 01 00 78 74 20 74 |........|.9..xt t|
|00005c30| 6f 20 65 61 63 68 20 6f | 74 68 65 72 20 69 6e 20 |o each o|ther in |
|00005c40| 01 00 73 01 11 50 23 46 | 23 20 3d 20 41 34 30 20 |..s..P#F|# = A40 |
|00005c50| 66 69 65 6c 64 2e ff ff | d2 54 68 69 73 20 66 6f |field...|.This fo|
|00005c60| 72 6d 75 6c 61 20 69 73 | 20 75 73 65 64 20 69 6e |rmula is| used in|
|00005c70| 20 61 6e 20 72 65 70 6f | 72 74 20 76 61 72 69 61 | an repo|rt varia|
|00005c80| 62 6c 65 20 69 6e 20 74 | 68 65 20 72 65 70 6f 72 |ble in t|he repor|
|00005c90| 74 20 62 6f 64 79 20 6f | 66 20 61 20 72 65 70 6f |t body o|f a repo|
|00005ca0| 72 74 2e 20 20 49 74 20 | 69 73 20 75 73 65 64 20 |rt. It |is used |
|00005cb0| 74 6f 20 63 6f 72 72 65 | 63 74 20 64 61 74 61 20 |to corre|ct data |
|00005cc0| 74 68 61 74 20 68 61 73 | 20 62 65 65 6e 20 69 6e |that has| been in|
|00005cd0| 63 6f 72 72 65 63 74 6c | 79 20 65 6e 74 65 72 65 |correctl|y entere|
|00005ce0| 64 20 62 79 20 61 64 64 | 69 6e 67 20 62 6c 61 6e |d by add|ing blan|
|00005cf0| 6b 73 20 74 6f 20 74 68 | 65 20 62 65 67 69 6e 6e |ks to th|e beginn|
|00005d00| 69 6e 67 20 6f 66 20 61 | 20 73 74 72 69 6e 67 2e |ing of a| string.|
|00005d10| 20 20 54 68 65 20 66 6f | 72 6d 75 6c 61 20 73 69 | The fo|rmula si|
|00005d20| 6d 70 6c 79 20 74 61 6b | 65 73 20 42 74 68 65 20 |mply tak|es Bthe |
|00005d30| 73 74 72 69 6e 67 20 69 | 6e 20 50 31 46 31 20 61 |string i|n P1F1 a|
|00005d40| 6e 64 20 74 72 75 6e 63 | 61 74 65 73 20 61 6e 64 |nd trunc|ates and|
|00005d50| 20 6c 65 61 64 69 6e 67 | 20 62 6c 61 6e 6b 73 2e | leading| blanks.|
|00005d60| 20 20 54 68 69 73 20 72 | 65 70 6f 72 74 20 47 76 | This r|eport Gv|
|00005d70| 61 72 69 61 62 6c 65 20 | 73 68 6f 75 6c 64 20 74 |ariable |should t|
|00005d80| 68 65 6e 20 62 65 20 73 | 74 6f 72 65 64 20 62 61 |hen be s|tored ba|
|00005d90| 63 6b 20 69 6e 74 6f 20 | 74 68 65 20 66 69 65 6c |ck into |the fiel|
|00005da0| 64 20 66 72 6f 6d 20 77 | 68 65 6e 63 65 20 69 74 |d from w|hence it|
|00005db0| 20 63 61 6d 65 2e 00 20 | 77 69 74 68 20 59 65 73 | came.. |with Yes|
|00005dc0| 0d 00 d0 03 25 72 76 31 | 20 20 20 20 20 2d 2d 20 |....%rv1| -- |
|00005dd0| 4f 6c 64 20 4b 65 79 20 | 56 61 6c 75 65 20 28 74 |Old Key |Value (t|
|00005de0| 6f 20 72 65 70 6c 61 63 | 65 29 ff 18 72 76 32 20 |o replac|e)..rv2 |
|00005df0| 20 20 20 20 2d 2d 20 4e | 65 77 20 4b 65 79 20 56 | -- N|ew Key V|
|00005e00| 61 6c 75 65 ff 36 72 76 | 33 20 20 20 20 20 2d 2d |alue.6rv|3 --|
|00005e10| 20 28 72 76 31 20 3d 20 | 50 23 46 23 29 20 20 28 | (rv1 = |P#F#) (|
|00005e20| 57 68 65 72 65 20 50 23 | 46 23 20 3d 20 6c 69 6e |Where P#|F# = lin|
|00005e30| 6b 20 6b 65 79 20 66 69 | 65 6c 64 29 ff 43 46 69 |k key fi|eld).CFi|
|00005e40| 65 6c 64 20 23 20 2d 2d | 20 4b 65 79 20 66 69 65 |eld # --| Key fie|
|00005e50| 6c 64 20 69 6e 20 6c 69 | 6e 6b 69 6e 67 20 70 61 |ld in li|nking pa|
|00005e60| 6e 65 6c 20 28 69 6e 20 | 73 75 62 72 65 70 6f 72 |nel (in |subrepor|
|00005e70| 74 29 20 6f 72 20 6d 61 | 69 6e 20 70 61 6e 65 6c |t) or ma|in panel|
|00005e80| 2e ff ff d6 49 6e 20 74 | 68 65 20 46 69 72 73 74 |....In t|he First|
|00005e90| 20 50 61 67 65 20 48 65 | 61 64 65 72 20 74 68 65 | Page He|ader the|
|00005ea0| 72 65 20 61 72 65 20 74 | 77 6f 20 70 72 6f 6d 70 |re are t|wo promp|
|00005eb0| 74 73 2e 20 20 54 68 65 | 20 66 69 72 73 74 20 28 |ts. The| first (|
|00005ec0| 72 76 31 29 20 70 72 6f | 6d 70 74 73 20 66 6f 72 |rv1) pro|mpts for|
|00005ed0| 20 74 68 65 20 6f 6c 64 | 20 6b 65 79 20 76 61 6c | the old| key val|
|00005ee0| 75 65 20 28 74 68 65 20 | 76 61 6c 75 65 20 69 6e |ue (the |value in|
|00005ef0| 20 74 68 65 20 66 69 65 | 6c 64 20 74 68 61 74 20 | the fie|ld that |
|00005f00| 68 61 73 20 65 73 74 61 | 62 6c 69 73 68 65 64 20 |has esta|blished |
|00005f10| 74 68 65 20 6c 69 6e 6b | 29 20 61 6e 64 20 74 68 |the link|) and th|
|00005f20| 65 20 73 65 63 6f 6e 64 | 20 28 72 76 32 29 20 70 |e second| (rv2) p|
|00005f30| 72 6f 6d 70 74 73 20 66 | 6f 72 20 74 68 65 20 6e |rompts f|or the n|
|00005f40| 65 77 20 76 61 6c 75 65 | 20 74 6f 20 62 61 73 65 |ew value| to base|
|00005f50| 20 74 68 65 20 6c 69 6e | 6b 20 ce 6f 6e 2e 20 20 | the lin|k .on. |
|00005f60| 49 6e 20 74 68 65 20 52 | 65 70 6f 72 74 20 42 6f |In the R|eport Bo|
|00005f70| 64 79 20 61 20 63 68 65 | 63 6b 20 69 73 20 6d 61 |dy a che|ck is ma|
|00005f80| 64 65 20 6f 6e 20 74 68 | 65 20 63 6f 6e 74 65 6e |de on th|e conten|
|00005f90| 74 73 20 6f 66 20 74 68 | 65 20 6c 69 6e 6b 27 73 |ts of th|e link's|
|00005fa0| 20 6b 65 79 20 66 69 65 | 6c 64 20 61 6e 64 20 64 | key fie|ld and d|
|00005fb0| 65 74 65 72 6d 69 6e 65 | 73 20 69 66 20 74 68 65 |etermine|s if the|
|00005fc0| 20 63 75 72 72 65 6e 74 | 20 72 65 63 6f 72 64 20 | current| record |
|00005fd0| 69 73 20 6f 6e 65 20 74 | 68 61 74 20 6e 65 65 64 |is one t|hat need|
|00005fe0| 73 20 74 6f 20 62 65 20 | 63 68 61 6e 67 65 64 2e |s to be |changed.|
|00005ff0| 20 20 49 66 20 69 74 20 | 69 73 20 6e 6f 74 20 74 | If it |is not t|
|00006000| 68 65 6e 20 74 68 65 20 | 72 65 63 6f 72 64 20 69 |hen the |record i|
|00006010| 73 20 73 6b 69 70 70 65 | 64 3b 20 6f 74 68 65 72 |s skippe|d; other|
|00006020| 77 69 73 65 20 74 68 65 | 20 d1 73 75 62 72 65 70 |wise the| .subrep|
|00006030| 6f 72 74 20 69 73 20 72 | 75 6e 20 61 6e 64 20 74 |ort is r|un and t|
|00006040| 68 65 20 63 68 61 6e 67 | 65 20 69 73 20 6d 61 64 |he chang|e is mad|
|00006050| 65 20 74 6f 20 74 68 65 | 20 6b 65 79 20 66 69 65 |e to the| key fie|
|00006060| 6c 64 20 69 6e 20 74 68 | 65 20 73 75 62 2d 70 61 |ld in th|e sub-pa|
|00006070| 6e 65 6c 20 61 6e 64 20 | 74 68 65 20 6b 65 79 20 |nel and |the key |
|00006080| 76 61 6c 75 65 20 69 73 | 20 61 6c 73 6f 20 63 68 |value is| also ch|
|00006090| 61 6e 67 65 64 20 69 6e | 20 74 68 65 20 6d 61 69 |anged in| the mai|
|000060a0| 6e 20 70 61 6e 65 6c 20 | 62 79 20 61 20 73 74 6f |n panel |by a sto|
|000060b0| 72 65 20 72 65 70 6f 72 | 74 20 76 61 72 69 61 62 |re repor|t variab|
|000060c0| 6c 65 20 69 6e 20 66 69 | 65 6c 64 20 63 6f 6d 6d |le in fi|eld comm|
|000060d0| 61 6e 64 20 69 6e 20 74 | 68 65 20 52 65 70 6f 72 |and in t|he Repor|
|000060e0| 74 20 42 6f 64 79 20 6a | 75 73 74 20 6f 75 74 73 |t Body j|ust outs|
|000060f0| 69 64 65 20 6f 66 20 74 | 68 65 20 0a 73 75 62 72 |ide of t|he .subr|
|00006100| 65 70 6f 72 74 2e ff 8b | 20 20 4e 6f 74 65 3a 20 |eport...| Note: |
|00006110| 49 74 20 69 73 20 69 6d | 70 6f 72 74 61 6e 74 20 |It is im|portant |
|00006120| 74 68 61 74 20 74 68 65 | 20 72 65 63 6f 72 64 73 |that the| records|
|00006130| 20 69 6e 20 74 68 65 20 | 73 75 62 72 65 70 6f 72 | in the |subrepor|
|00006140| 74 20 62 65 20 61 6c 74 | 65 72 65 64 20 62 65 66 |t be alt|ered bef|
|00006150| 6f 72 65 20 74 68 65 20 | 72 65 63 6f 72 64 20 69 |ore the |record i|
|00006160| 6e 20 74 68 65 20 70 61 | 72 65 6e 74 20 70 61 6e |n the pa|rent pan|
|00006170| 65 6c 20 6f 72 20 65 6c | 73 65 20 74 68 65 20 6c |el or el|se the l|
|00006180| 69 6e 6b 20 77 69 6c 6c | 20 62 65 20 62 72 6f 6b |ink will| be brok|
|00006190| 65 6e 2e 00 6f 20 74 68 | 65 20 6e 65 78 74 20 70 |en..o th|e next p|
|000061a0| 1f 00 a1 00 16 50 23 46 | 23 20 3d 20 42 69 72 74 |.....P#F|# = Birt|
|000061b0| 68 64 61 74 65 20 46 69 | 65 6c 64 ff ff 86 55 73 |hdate Fi|eld...Us|
|000061c0| 65 64 20 74 6f 20 64 65 | 74 65 72 6d 69 6e 65 20 |ed to de|termine |
|000061d0| 61 67 65 20 74 6f 20 74 | 68 65 20 79 65 61 72 2e |age to t|he year.|
|000061e0| 20 20 4e 6f 74 65 3a 20 | 54 68 69 73 20 66 6f 72 | Note: |This for|
|000061f0| 6d 75 6c 61 20 6d 61 79 | 20 69 6e 63 6f 72 72 65 |mula may| incorre|
|00006200| 63 74 6c 79 20 73 74 61 | 74 65 20 61 20 70 65 72 |ctly sta|te a per|
|00006210| 73 6f 6e 27 73 20 61 67 | 65 20 69 66 20 74 68 65 |son's ag|e if the|
|00006220| 20 64 61 74 65 20 69 73 | 20 77 69 74 68 69 6e 20 | date is| within |
|00006230| 61 20 77 65 65 6b 20 6f | 66 20 62 69 72 74 68 64 |a week o|f birthd|
|00006240| 61 74 65 2e 00 20 69 73 | 20 73 69 6d 70 6c 79 20 |ate.. is| simply |
|00006250| 61 20 6d 69 6e 75 73 20 | 73 69 67 6e 20 28 2d 29 |a minus |sign (-)|
|00006260| 06 00 57 00 2c 53 75 62 | 73 74 72 69 6e 67 5b 22 |..W.,Sub|string["|
|00006270| 20 32 31 35 20 4f 61 6b | 20 4c 61 6e 65 2c 20 48 | 215 Oak| Lane, H|
|00006280| 61 72 74 66 6f 72 64 2c | 20 43 54 22 3b 30 3b 32 |artford,| CT";0;2|
|00006290| 5d ff 27 54 68 69 73 20 | 66 6f 72 6d 75 6c 61 20 |].'This |formula |
|000062a0| 77 69 6c 6c 20 72 65 74 | 75 72 6e 20 74 68 65 20 |will ret|urn the |
|000062b0| 73 74 72 69 6e 67 20 43 | 54 2e 00 74 65 20 66 69 |string C|T..te fi|
|000062c0| 03 00 00 00 07 00 00 00 | 00 00 00 00 72 65 76 65 |........|....reve|
|000062d0| 72 73 65 20 64 61 74 65 | 20 63 61 6e 20 62 65 20 |rse date| can be |
|000062e0| 75 73 65 66 75 6c 20 66 | 6f 72 20 72 65 70 6f 72 |useful f|or repor|
|000062f0| 74 73 20 61 6e 64 20 66 | 6f 72 20 73 6f 72 74 69 |ts and f|or sorti|
|00006300| 6e 67 20 72 65 63 6f 72 | 64 73 20 66 6f 72 20 64 |ng recor|ds for d|
|00006310| 69 73 70 6c 61 79 20 69 | 6e 20 61 20 77 69 6e 64 |isplay i|n a wind|
|00006320| 6f 77 2e 20 20 54 68 65 | 20 66 69 65 6c 64 20 28 |ow. The| field (|
|00006330| 66 6f 72 6d 61 74 20 47 | 2d 5a 5a 5a 5a 39 29 20 |format G|-ZZZZ9) |
|00006340| 63 6f 6e 74 61 69 6e 69 | 6e 67 20 74 68 65 20 66 |containi|ng the f|
|00006350| 6f 72 6d 75 6c 61 20 69 | 73 20 67 65 6e 65 72 61 |ormula i|s genera|
|00006360| 6c 6c 79 20 68 69 64 64 | 65 6e 20 73 6f 20 61 73 |lly hidd|en so as|
|00006370| 20 74 6f 20 61 76 6f 69 | 64 20 65 6e 64 2d 75 73 | to avoi|d end-us|
|00006380| 65 72 20 63 6f 6e 66 75 | 73 69 6f 6e 2e 00 64 20 |er confu|sion..d |
|00006390| 62 65 66 6f 72 65 20 72 | 75 6e 6e 69 6e 67 20 74 |before r|unning t|
|000063a0| 07 00 98 00 1e 50 23 46 | 23 20 3d 20 47 20 6f 72 |.....P#F|# = G or|
|000063b0| 20 48 20 66 6f 72 6d 61 | 74 74 65 64 20 76 61 6c | H forma|tted val|
|000063c0| 75 65 2e ff ff 2c 52 6f | 75 6e 64 73 20 66 69 65 |ue...,Ro|unds fie|
|000063d0| 6c 64 20 76 61 6c 75 65 | 20 75 70 20 74 6f 20 74 |ld value| up to t|
|000063e0| 68 65 20 6e 65 61 72 65 | 73 74 20 6e 69 63 6b 65 |he neare|st nicke|
|000063f0| 6c 2e ff 47 45 78 61 6d | 70 6c 65 3a 20 38 30 2e |l..GExam|ple: 80.|
+--------+-------------------------+-------------------------+--------+--------+
Only 25.0 KB of data is shown above.
